Nic Larsen’s Profile

Community member since June 2018

points
496

20

I am trying to set color buttons to the status of each row. Currently I am getting #UNPARSEABLE

My formula is:

=IF([Status]@row = "Complete", "Yellow", " ")IF(AND([Status]@row = "Pending", "Yellow", " ")IF(AND([Status]@row = "InProcess", "Yellow", " ")IF(AND([Status]@row = "In Progress", "Yellow", "

1

I've looked through numerous posts and sent an email to Smartsheet but am still on the hunt for the exact answer. (I do have a HelpDesk ticket in.) 

I'm creating a sheet that will be used to conduct document audits and I need to know when an audit is 

1. Previous to due date

2. Due 

3. Overdue

4.