Sign in to join the conversation:
I would like the column "Done" to be checked automatically if the % Complete is changed to 100%. I am using the formula below which is not working:
=IF([% Complete]3 = "100%", 1)
Any suggestions?
If your % Complete column is formatted to be a percentage, you will need to replace "100%" with 1 (no quotes).
=IF([% Complete]@row= 1, 1)
thank you so much!!! it worked
Happy to help!
Smartsheet stores percentages as a fraction of 1, so
100% = 1
75% = 0.75
50% = 0.5
25% = 0.25
0% = 0
and everything in between.
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
Hi, I am trying to get a column that provides the Date (easy with Record a Date) but I need the TIME as well. Most of my tables I just use the right function on the Modified Date because the only thing updating those tables are automations or data imports. But a few tables have automations, data imports, and manual inputs.…
I’m hoping to get a second set of eyes from the community in case I’m missing something obvious or there’s a cleaner pattern I should be using. I’ve used ChatGPT to try and help me group/organize my situation coherently…. Because at this point I feel crazy… I’ve literally worked on this for hours. Environment •Smartsheet…
