Can I use a formula for this date feature?
I'm working on transferring my excel system into smartsheet.
I am creating a newsletter regarding events that happen during a certain period.
In excel I can use a forumula based on a date. For example if the publish date is 23/5/2018, it will relate to events happening between 24/5/2018 and 3/6/2018. In excel , the event start date column would have a formula e.g. =sum(C13+10) to create right date range.
How do I replicate this as important information in the same row?
Comments
-
You can use dates in your formulas. However, while Excel and Google Sheets use letters to refer to columns - Smartsheet uses the column title. Also, you can use simple math to add or subtract calendar days to a date. So your formula would look something like this. =[date column]13+10
This would add 10 days to the date column. This formula would need to be in a date column itself (as is) or used in reference to another formula like in an IF statement. Here is an example statement that would reference a "Date Column" and compare it to another date column to return text in a text/number field.
IF([date column title]13+10 > [Due date column]13, "Overdue", "On Time")
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives