Formula for Status Ball
Answers
-
I'm trying to do something similar but not sure how (sorry if my formula is in french)
=IF([État de la tâche]1 = "Complété"; "Vert"; IF(AND([État de la tâche]1 <> "Complété"; TODAY() > [Date de fin]1); "Rouge"; IF(AND([État de la tâche]1 = "Pas Commencé"; "Bleu"; IF(AND([État de la tâche]1 = "En cours"; "Jaune"))))))
This formula basicaly says if in cell 17 in a certain column i have selected either complete, not started or in progess from a dropdown menu then show a certain color symbol and if the task is not complete and the date is overdue then show a red symbol. What I would like to add to this formula if the cell is empty (didn't select anything from the dropdown) then leave the cell, where i ususally see a color symbol, blank. Right now i get a red symbol because i also don't have an end date to the task
-
Hi @janiebn
You can add a statement right at the beginning that says if the cell is blank, return blank.
I would also suggest changing your row numbers (eg. [État de la tâche]1) to @row ([État de la tâche]@row), so that you can make this formula a Column Formula.
Try:
=IF([État de la tâche]@row = ""; ""; IF([État de la tâche]@row = "Complété"; "Vert"; IF(AND([État de la tâche]@row <> "Complété"; TODAY() > [Date de fin]@row); "Rouge"; IF(AND([État de la tâche]@row = "Pas Commencé"; "Bleu"; IF(AND([État de la tâche]@row = "En cours"; "Jaune")))))))
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!