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 am working on creating a streamlined way to obtain information from our 66 non-profit groups in order to request specific credentials based on what zone their group will be working in. I only need full name and email addresses from the group leads. All other information needed, I and operations managers would enter. I…
I'm trying to create a COUNTIF formula in a Sheet Summary field where the range is a Text/number column that contains a column formula. I keep getting an INVALID DATA TYPE error no matter what I do. The Sheet Summary field is also defined as a Text/number field. What am I doing wrong? Note, I get the same error when I try…
I am trying to add together 2 columns. I used the formula It is only adding one column.
