Hello!
I'm trying to setup a project plan for when a task is marked 'complete' it auto-fills the 'Finish Date' column. Would I use an If, then formula? If so, what would that formula look like?
Thanks!
Crystal
Hi Crystal, this functionality is not currently available without using a third party tool like Zapier. We reverse-engineered our process to have the person enter a date and then have the status update accordingly.
Thanks, Mike! This is helpful. I'll try that approach.
Sounds good. Let me know if you have any questions! We created an Actual Start and an Actual finish date field to measure if the task was in progress or complete and changed the dropdown field with an IF function based on the dates being populated.
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
