Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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!
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.
