Return a cell value based on multiple variables

waygjlon

I am having trouble working out a formula to put into a cell. I want the cell to change, based on the value in a cell. 

If the 'status' cell in my document is marked as 'complete', I want to change a cell at the end of the document to 'Complete'. If the status cell is marked with anything else other than 'Complete', I want the cell at the end of the document to return the data that is currently in the 'Owner' cell on my document.  

How do I do this?

Andrée Starå

Hi Gary,

Try this.

=IF(Status@row = "Complete"; "Complete"; Owner@row)    

The same version but with the below changes for your and others convenience.  

=IF(Status@row = "Complete", "Complete", Owner@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

waygjlon

No it didn't unfortunately. I've had to use multiple workarounds to implement this formula: 

=IF(OR(Status111 = "Complete", Status111 = "Cancelled", Status111 = "On Hold"), "Other", Owner111)

My card view then filters out any projects that are categoriesed as 'Other'.

I've posted another question as the auto-fill solution for fomulas in Smartsheet seems archaic.  

https://community.smartsheet.com/discussion/auto-fill-outdated 

Andrée Starå

Ok.

It seems like your formula is more complicated than it probably needs to be, but the important part is that it's working for you.

I'll take a look at the other thread as well.

Best,

Andrée