How do I get round dates being pulled through by formula issue?
I am using index match to pull dates from another smartsheet. I am also using resource manager which does not like dates which are being pulled through via a formula. At the moment I am copying and pasting these values. This is messy and room for error.
Any suggestions
Answers
-
Depend on your use case, you might not have to use any formula.
You can simply link the cells with the dates in the other SS.
If you need matching dates for certain columns, VLOOKUP might work
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!