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.
Hello! I have this formula that will check the box if the date in a second column is in the past. Is there a way to include if the date is 60 days in the future? Check the box if the date in Column 2 is either (1) in the past or (2) 60 days in the future. IF([GWO - BST (2yr)]@row < TODAY(), 1, 0) Thank you in advance!
Is there a way to automatically update my dropdown list for a form if I have a new item added? I have a New Order Entry form. I have a dropdown list of customers, but if it is a new customer, there is a checkbox to allow more fields to open up to enter that information. If that information is added, it gets copied to a…
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
