Dates and assignee info pulling through as formulas so can't use Gaant view.
I am pulling though dates and assignee information from another smartsheet so these obviously pull through as a formula. Of course this means I now can't use this current sheet in Gannt view and this is not ideal. Any ideas suggestions would be welcome as currently manually copying and pasting into other columns and this has room for error.
Answers
-
You can use formulas for Gantt view. Just not Column Formulas. Depending on how new rows are added, autofill should still grab formulas for new rows.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 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!