Note: Since releasing this video, Smartsheet has created a new automated workflow to change cell values, which performs the same action shown here albeit in a simpler and easy to manage way. Details on this automation can be found at help.smartsheet.com/articles/2482299-change-cell-value-in-an-automated-workflow
@mikemcnh3 жыл бұрын
This was great, and was the solution I needed. Thanks for creating this video! Will be the coolest work thing I will do today :-)
@SchoolofSheets3 жыл бұрын
Glad it helped!!!
@person810453 жыл бұрын
What happens in the case where the due to so many changes and exponential growth of data tracked and entered the COPY sheet exceeds sheet cell limits. Would this not destroy the entire process?
@SchoolofSheets3 жыл бұрын
Yes - it could. Simply put, a workflow would need to be in place to clear the COPY Sheet (I've run into this before). However, since this video was created a new Smartsheet automation (change cell value) has become available which is a better way to manage this process.
@vanessabarranta46573 жыл бұрын
This was really helpful. I'm new to the match function; does the search type need to be identified as "0" if you're going to change the status out of order? It gets a little wonky around the 5:32 mark when adding Task 4. Thanks in advance!
@SchoolofSheets3 жыл бұрын
The last portion of the match function refers to if the reference range is sorted ascending (1), descending (-1), or not sorted (0). Unless you know your range is sorted in a particular order I would 0 as it defaults to 1. Having the wrong value here can result in return values that are incorrect, or #NO MATCH errors.
@GmLm083 жыл бұрын
Hi, at 5.33 you added task 4 and the start date automatically updated before you changed the status to in progress. How do you prevent this so that the start date will only appear when status has changed? I have just followed this video and now all my start dates are showing as today even though they haven’t been changed to in progress yet 🤔 Thanks
@SchoolofSheets3 жыл бұрын
Hey Gavin, thanks for watching and commenting. I made a video to answer your questions, please check it out at kzbin.info/www/bejne/fZ6adZaDZt1qn80. Let us know if you have any other questions. :) Dan
@aatishchaudhary41953 жыл бұрын
If I change the status In progress to Completed and change it back to In Progress next day does the start date get change again?
@SchoolofSheets3 жыл бұрын
It could depending on how you set up your formula. If you capture the most recent change than yes, it would.