Sign in to join the conversation:
I have a % Complete column and a Status column adjacent to each other. I would like to automatically set the % Complete to 100% if I change the Status column (drop-down) to complete. Is this possible?
=IF(Status26 = "7 - Closed", 1, IF(Status26 = "2 - In Progress (Active)", 0.5))
the catch is that you can't put both a manual value or a calculated value (as above)... Maybe if you use a "hidden" column to store the formula somehow... Perhaps this puts you on the right track regardless... good luck!
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
This discussion was created from comments split from: Generate documents from row data.
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday
