Sign in to join the conversation:
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.
I need to pull the Form ID (and other columns) from Sheet B into Sheet A. These conditions all need to be met: Departure Date ⇒ Date Field 1 Departure Date =< Date Field 2 Destination (Sheet B) contains City (Sheet A) Name (Sheet B) contains Last Name (Sheet A) This is the current formula I have: =INDEX(COLLECT({Form ID},…
hi team for not getting quick response copy form smartsheet what are the reasons
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
