Tuesday, December 6

How to Add Days to a Date in Smartsheet

Smartsheet is a popular job management software. It offers different options to help you plan and manage your projects, tasks, calendars, etc. Keeping track of dates is an important factor in all management software. If you want to learn how to add days to a date in Smartsheet, be sure to read on.

How to add days to a date?

If you want to keep your projects in order and select the due date in Smartsheet, you can do so by applying different formulas.

If you have a start date for your project, say June 1, 2012, and you have to finish it before the end of the month, what you can do is apply this formula: =[Start Date]@row + 29 in the expiration date column.

You can write it, but you can also use this option:

  1. Writes “=” in the due date column, next to the start date.
  2. Select the start date.
  3. Place a plus sign (+) next to the start date.
  4. Put the number of days you want to add to the date (in this case, 29).
  5. Hit “Enter.”

That’s it! You have successfully added days to a date. The numbers you enter are treated as days by default.

Add the same number of days to each start date

What happens when you have different start dates for your project, but you have 30 days to complete each one? If you want to enter due dates with a simple formula, follow these steps:

  1. Writes “=” in the due date column, next to the start date.
  2. Select the start date.
  3. Put a plus sign (+) next to the start date.
  4. Put the number of days you want to add to the date (in this case, 30).
  5. Hit “Enter.”
  6. Select that cell.
  7. You will see a small square in the lower right corner of the cell. Press the square and start moving it down / up.
  8. Now your formula will automatically transfer to all cells you selected.
See also  During 2021, Xbox Game Pass added titles with a total value of more than $ 6000 USD | Levelup

Add a different number of days to each start date

It will often happen that different projects need to be completed in different time frames. In this case, it is better to use the column “Duration”. Here, you can specify the number of days each project will take. Then you can use a simple formula to calculate the due date:

  1. Writes “=” in the due date column, next to the start date.
  2. Select the start date.
  3. Put a plus sign next to the start date.
  4. Select the duration from the duration column.
  5. Hit “Enter.”
  6. You will see the due date for that project. If you want to apply this formula to your other projects, use the little square at the bottom right of the cell to move it down / up.

What happens when the start date changes?

You decided to start your project a little later, but you are not sure if this will affect your formula. Do not worry! Once you change your start date, Smartsheet will automatically adjust the end date. If the duration remains the same, it will simply count the days from the date you entered.

What happens when the duration changes?

If your project needs to be completed in a shorter period, or if you want to extend the period until it is completed, you can do it in two ways. You can change the number in the duration column or change the number in the formula, depending on how you originally created the formula.

If you specified the number of days in the formula, you can remove it and insert the new number.

If you used the “Duration” column, you can change the number there, hit “Enter” and the formula will automatically update, showing you your new expiration date.

See also  How to watch Dallas Mavericks at Memphis Grizzlies: live stream, TV channel, start time

Subtract days from a date

If you need to subtract days from a specific date, you can use a simple formula:

  1. Writes “=” in the column where you would like to get the result.
  2. Select the date.
  3. Put a minus sign (-) next to the date.
  4. Enter the number of days you would like to subtract.
  5. Hit “Enter.”

Enabling dependencies

This function is a means of automatically calculating the dates when duration values ​​(how long something will last) and predecessors change (what must happen before something else happens). If you decide to enable this, here are some of the features you can use:

  1. If you enter the start and expiration date, the duration column will be calculated automatically.
  2. You can enter the number of business days per week, holidays, vacation days, etc. This will help you calculate the due dates for your projects.
  3. If you change the start and / or due date, the corresponding column will be adjusted automatically.

This is how you can enable dependencies:

  1. Select the column you want and tap “Edit project settings”.
  2. Select the “Dependencies Enabled” check box.
  3. You will see new options appear.
  4. Select the columns to be used as the “predecessor column” and the “duration column”. If you don’t have these columns, Smartsheet will insert them automatically.

It is important to note that you cannot put formulas in columns once you have enabled this feature.

How to change the date format in Smartsheet?

The date format displayed in Smartsheet is based on the regional preferences that you specified when creating your account. For example, if your “Regional Preferences” are set to “English (United States)”, the dates will be displayed in the month / day / year format. You can change this by following these steps:

  1. Abra Smartsheet.
  2. Go to the “Account” icon.
  3. Touch “Personal Settings.”
  4. Touch “Settings.”
  5. Choose an option under “Regional Preferences.”
  6. When you select an option, you will see the preview of the date and number formats, so you can choose what you want before saving your changes.
  7. Once you choose an option, tap “Save.”
  8. The new settings will be applied to your sheets.
See also  This is the Watch GT 3, with renewed health functions and a lot of autonomy

Smartsheet keyboard shortcuts

Smartsheet offers a variety of keyboard shortcuts that you can use for dates. This will allow you to work faster and save time while working on sheets. You can find some of the shortcuts below:

  • t – Insert today’s date.
  • + n: enter a date in days from today. For example, if today is 09/06/2021, pressing +3 will enter 12/06/2021.
  • -n – Enter a date in days before today. For example, if today is 09/06/2021, pressing -5 will enter 04/06/2021.
  • Sun, Mon, Tue, Wed, Thursday, Friday, Saturday: Entering a date that matches the specific day of the current week. For example, if today’s date is 09/06/2021, typing “sun” would enter 06/06/2021.
  • yes: yesterday’s date.
  • tom – Tomorrow’s date.
  • last week – Current date -7 days.
  • next week – Current date +7 days.

It is important to note that these abbreviations only work for the English language.

Smartsheet: Explained!

You have now learned how to add days to a date in Smartsheet, and you have more information about the software itself. This is reliable, efficient, and time-saving software that will help you ensure that all your projects are completed on time. So if you are already using Smartsheet or thinking about using it, you will definitely learn more by reading this guide.

Have you ever used Smartsheet? Let us know in the comment section below!


Leave a Reply

Your email address will not be published. Required fields are marked *