Sign in to join the conversation:
I am trying to auto populate a column based on a selection I make in another column.
This may not be possible. It depends if your assignee column is in a contact column or not. Contact columns cannot contain formulas, therefore they are not automatable. If you just need a name reference there, then you could make your asignee column a text/number type field and use a formula similar to the following: =IF([Campaign Type]23 = "Video", "User's Name")
However, you won't be able to send any emails, updates, or data based on that column. So there are drawbacks.
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…
