I need help writing the formula to automatically check the box when any one of these three values is selected: Complete, Cancelled, or Passed_Conditionally.
Thanks for the question. This can be done using the IF() and OR() functions. More on all of the functions Smartsheet offers can be found here (https://help.smartsheet.com/functions). Here's an example of how this could look:
=IF(OR([Status Column]# = Complete, [Status Column]# = Cancelled, [Status Column]# = Passed_Conditionally), 1, 0)
To make this work for you, replace [Status Column] with the name of the column that the values are in, and replace the # with the row number you're placing this formula in. Once it's working in one row, you can drag-fill this down the column for any other rows you need this in. More on drag-fill can be found here (https://help.smartsheet.com/articles/518318#dragfill).
Works great! Thank you
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.