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:
=IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow")))
i.e.
=IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))
Hey @Kristin McClinton
I moved a few parentheses around.
=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))
cheers
Kelly
Morning Everyone, Quick question, everyday we move records from a Grid to a Master Table for todays deployments across the country. All of those records are flagged with the "In Queue" status when they are copied over to the Master table. When the Tech arrives on site the "Card" is moved from "In Queue" to "In Progress",…
Hi everyone, I am trying to set up a standard "Move Row" automation to archive completed items, but my newly created destination sheet is completely invisible to the search bar in the automation builder. Because the "Select a destination sheet" window was recently updated and no longer has the manual Workspace/Folder…
Hi, We are on an Enterprise Smartsheet plan with SSO enabled in the US region. Have created a workspace, dashboards, contact list and etc. and shared it with an external contractor. External contractor already has an account in the Australia region. Tried to setup another account with the same email address (with Gmail) in…
