Sign in to join the conversation:
Hi!
I have 7 columns that have check boxes. When all 7 columns in one row are all checked, I would like a column that will auto populate a "completed" date. Is this even possible or am I insane? haha! Thank you!
This is not currently possible without a third-party solution like Zapier. There is no date-stamp option in Smartsheet although it is a HIGHLY requested item. I recommend that you submit a product enhancement request to add your vote to their list.
There is a possibility of adding a Modification date system column to your sheet, but anytime something changes on the row the modification date would change too.
Hi,
It's possible, but you would need to use a third-party tool like Zapier or similar.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I am trying to replicate a Kata chart in Smartsheet and need help.
I have an automation set up to email certain team members if values change on a sheet. The trigger is set to Daily so that it doesn't send them a bunch of emails every time I add data. What I want to know is, at what time do these usually run? I want to make sure that it is not sending out the email before I have finished…
What is a formula to count the # of tasks that are overdue, based on a date?