Can SmartSheet copy data based on two dates?
I'm looking for help with a formula that could copy data from one cell to another in the same sheet based on a start and end date. If the row is "active" today's date is between the start and end dates, it will copy the data over.
When there are future dates as is shown with the row that says New Allocation, when today's date reaches that start date, it will copy the allocation data into the first column. Right now I have a workflow that clears the first column when an allocation ends. Would I still need that workflow if the formula is checking start and end dates for copying the data? Would the formula also clear out the data when the end date is reached?
Answers
-
Let's try this. Since you haven't provided column names, I'll call them:
Following the logic you want, place this in Column A (with the correct column names, of course):
=IF(AND(D@row <= TODAY(), E@row >= TODAY()), F@row, "")
This says that IF Today is on or after the date in Column D, AND Today is on or before the date in Column E, then set Column A's value to that of Column F; otherwise, leave Column A blank.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you. I will try the formula and let you know if it works.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!