Using a Flagged Column to fill in a Cell
Hi all,
Is it possible to create a formula that would complete a STATUS column when a flagged cell is activated (Like a checkbox). In the attached example, I would like to automatically fill in the Complete Status when the check box is TRUE in the DONE column
To be clear, I am using =IF(Done@row = 1, "Complete") now but that wipes out the other entries (In Progress, etc.)
Best Answers
-
You would need to first establish the logic for "In Progress" and "Not Started". Then you can use a nested IF formula.
=IF(Done@row = 1, "Complete", IF(logic_for_not_started, "Not Started", "In Progress"))
-
The second "@row". It should be all lowercase, but you have a capital "R".
Answers
-
You would have to either automate all of the different options for statuses or you would have to keep it all manual.
-
I can do that if I know what the complete Syntax is for the formula. I would need to know how to express "If(Done@row=0), "In Progress, "Not Started"
-
You would need to first establish the logic for "In Progress" and "Not Started". Then you can use a nested IF formula.
=IF(Done@row = 1, "Complete", IF(logic_for_not_started, "Not Started", "In Progress"))
-
Thank you , as always, Paul. I seem to now have a syntax error someplace.
=IF(Done@row = 1, "Complete", IF(Done@Row=0, "Not Started", "In Progress"))
Returns, "UNPARSABLE"
Guessing that I cannot have two criteria in a single argument
-
The second "@row". It should be all lowercase, but you have a capital "R".
-
You are a Stud, my friend! It's always the stupid things with me....
-
Happy to help. 👍️
-
Interesting note; Making this a Column formula removes the drop down. Need to keep it as a cell formula.
-
Yes. That is because when it is applied as a column formula, the cell cannot be manually edited. This is true for column formulas in all column types.
Help Article Resources
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
Check out the Formula Handbook template!