Sign in to join the conversation:
I would like to have the parent row of my health column automatically be red, green or yellow based on the average health of it's child rows.
Does anyone have an idea of how to accomplish this?
I replied on your other thread about this.
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…
Hi, I’m using Smartsheet with a Master Sheet(All over Projects Basic Summary) and Individual project sheets that have multiple phases. When I change the Assigned Person in the Master Sheet, I want: •It to update only phases that are Not Started or In Progress •It should not change phases that are Completed Is this…
