Sign in to join the conversation:
Dear,
I am planning to write an if function for 3 criteria.
IF(AND([In Progress - Late]1 >= 1, [At Risk]1 >= 1),[In Progress - On Track]1>=1,) "Red","")
I know I am writing it wrong. Can anyone help me structure the formula please?
Cheers!
Hi,
What column types are you using?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
You just misplaced a comma is all...
On Track]1>=1,) "Red"
move the comma to the other side of the parenthesis.
On Track]1>=1), "Red"
Cheers mate for spotting that error.
Cheers for your response, the problem is solved.
I'm always happy to help!
Have a fantastic weekend!
Andrée
Happy to help!
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
