Sign in to join the conversation:
In my project sheet, I have a Task Complete tick box.
I would like a date to be placed in the Reminder Date column if the box is not ticked by the Estimated Delivery Date.
Is this possible?
=IF([Task Complete]1 = 0, TODAY(), "")
Will post todays date if the checkbox is empty. Change today() to whatever equation you want in that formula.
Hi Team, How can I prevent a non admin end user from deleting a comment or comment thread in the dynamic view? Also, how can I notify the end user by email of the comment sent?
Is there a way to create back and forth conversations in the Smartsheet dynamic view with clients about their request that also records the back-and-forth history? I created a feature in the details panel that points at the comment text box which I add comments BUT if the requestor responds back, historical comments can be…
I'd like to pull data from a Smartsheet row, having designated specific columns, and put it into a document that can be printed.