Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Make Stars yellow by Default
I am creating a New Hire Checklist and one of the columns is called required. If that row's task is required the start will be checked and show up yellow. How do I make all the starrs in the required colum yellow by default? So we have to uncheck only what isn't required instead of vice versa.
Comments
-
JBogert - add this formula to a star cell then copy it down the entire column:
=1
A “1” will enable the star in the cells. This formula will be auto-filled to any new row (with data) that you add to the sheet. Once you have added the formula to the entire column, all the stars will be starred and when you add a new row with data, the star will contain the formula with will enable the star.
The auto-fill function will work if you have the exact same formula two rows above or below the new row you added. This means if you insert a new row in-between two rows that have been ‘un starred’ the formula will not be copied to that new row.
-
Thank you! that did the trick.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives