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.
Rookie Stage - Status RYGB
I dont even know where to start:
Column Stage Column Status Dropdown List
RED Ball Not Started
Green Ball In Progress
Yellow Ball Waiting
Blue Ball Completed
How and Where do I put in a formula to select from Status dropdown list Not Started and have
the Red Ball show up automatically in Column Stage?
I know this must be simple. But have no I idea where to start. Please help asap.
Comments
-
That's a formula for example (depending on your colums)
-
note that 3 refers to the row number because I was hovering over the status cell on that row to view the formula
-
very new to formulas do i put at top of column so that all rows follow this
-
Kat, would you be interested in setting the formulas in my sheets and I would pay you for your time?
-
You put your formula in the cell you want to display the answer. So if you want the formula for the entire Status column write your formula in the first cell on the first row of your column. Then in the lower right hand corner of that cell when you click once on it and hover you'll get a big plus sign. Click on it and drag it down to the last cell in your column. Let go and now the formula is in all those cells in the column. If your sheet has hierarchy in it you may or may not want the formula in the cell on the parent row.
You can also copy a cell the formula is in and paste it to another cell.
Thanks for the offer Schultis. I'm not the best formula writer. I'm lucky, in that, I manage and work with programmers; they're really good with logical statements
-
Go to Smartsheet Template and under Featured Templates there is a sheet called Smartsheet Formula Examples. Use that template; lots of help and examples there and it shows you how they actually work not just abstract equations
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives