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 am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
I just started using the Table View for lists of contacts. I added a Format Rule that would highlight the entire row (except the Email Address field) if the Email Address cell is "blank". A second rule highlights just the Email Address cell itself in a slightly darker color if Email Address cell is "blank". This gives a…
