Trending in Formulas and Functions
-
Checking off a box in one form when another is filled out?
Hello! I am very, very new to Smartsheet so please forgive me if this isn't the right place to ask or a dumb question. I am attempting to make a sheet that records when someone has filled out a form on another sheet. The original sheet is a form for a customer service survey, and the one I want to make records when and if…
-
Using IF with CONTAINS and AND for multiple columns
I am looking at two different columns - one is called Status and the other Priority. I would like to have a formula/function setup that will look for "Open" within the Status column and "High" within the Priority column. If it finds "Open" and "High" together in any row, I want a "True" value returned. This will be used in…
-
Move Row to New Sheet
I'm trying to figure out how to move a row that contains "New Trip Report" when a new row is added containing "Corrected trip report" and the Report ID's match. For example: see screen shot. Adding row 2 containing Report ID TR00001TX115 would trigger moving row 1 to a new sheet. If anyone knows how to do this, please let…