Convert excel date formula to Smartsheet
Answers
-
Hi Sidonia
You have a few options but to recreate it exactly as written, assuming your smartsheet column names are named exactly as referenced above
=([Year End]@row-Eligible@row)/7
The easiest way to ensure the correct cell syntax is to click in the cell desired while writing the formula, and smartsheet will insert the right column name and row reference. You might find this information helpful.
cheers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 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!