Receiving unparseable error when selecting a field in one column and wanting a specific result in another field. This is the formula. What am I missing?
=IF([Submit for Approval]1,1[Manager Approval]1 = "Submitted")
See attached
First of all, you can't control the contents of a cell from a different cell. You need to put the formula in the cell you want the results to appear in.
In this case, try, putting the following formula in the Manager approval field.
=IF([Submit for Approval]@row, "Submitted", "Your Text Here")
If you want the field to be blank when the submit is blank then erase, "Your Text Here. Or put in a different statement for when its not submitted.
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
