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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 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!