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
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
