Sign in to join the conversation:
Please can someone help me with a way to indicate the conclusion date of a task, automatically?
Once I have a status set as finished, I need the current date to be "locked" on a cell and no changed/updated anymore.
Hi Guilherme,
You would probably need to use a third-party solution like Zapier or similar for this.
A possible workaround could be to lock the row automatically with Alerts & Actions.
Would any of those options work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
You might consider changing up the process. We started using Actual Start and Actual End date columns to determine whether a project was Not started, In Progress, or complete. We then applied a formula to the Status column and locked it down so that a status couldn't be changed manually and overwrite the formula.
=IF(AND(ISBLANK([Actual Finish]@row), ISBLANK([Actual Start]@row)), "Not Started", IF(ISDATE([Actual Finish]@row), "Complete", IF(ISDATE([Actual Start]@row), "In Progress")))
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?
