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.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 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!