if blank and if not blank then display a word
We are trying to do a check in and out smartsheet for the people on our team that travel a lot. We have incorporated Google Forms (because Smartsheet Forms is extremely limited) so that we can restrict who sees the Smartsheet. So each person has a link to their own editable google form so that they can edit their own line as many times as they want and constantly update where they are at. So what I need is.
- Formula that says when someone is "Available" or "Not Available"
- I have currently: =IF(ISBLANK([On Job]@row), "Available", IF(NOT(ISBLANK([On Job]@row, "Not Available"))))
- I get the #INCORRECT ARGUMENT SET error when I put anything into the "On Job" column
Any help would be much appreciated!