Sign in to join the conversation:
Hi,
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!
Hello,
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
I have existing sheets, reports and dashboards I would like to rename. I am going into the sheet etc. selecting file, rename, renaming and then clicking out of the name box. it appears to have worked. However, when I go back to browse the file reverted back to the previous name. I'm not sure what I am doing wrong.
This discussion was created from comments split from: Workaround for Grouped Reports with multi-select dropdowns.
Good afternoon, Somehow I deleted an entire smart sheet of information. I went into the activity log and I was able to take a snapshot, but now Smartsheet is not letting me import the new information in the smart sheet
