Sign in to join the conversation:
In my sheet I would like the 'Status Level' column to autochange to 'Complete' when the checkbox for completed is checked off. Is there a formula to so this with?
While there potentially is a way to set this do what you are asking, the challenge will come with if you or someone else changes the dropdown status. It would be easier to have the checkbox for complete auto check when the dropdown says complete. If you populate a dropdown field with a formula, then manually choose a dropdown option, it will overwrite the formula and would stop working. I would stick with marking items as complete via the dropdown or come up with a method for checkboxing the other status' so that no one is manually setting any of the dropdown statuses. Does that make sense?
While this post does not speak directly to your request, the concept and solution are the same.
http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/
Craig
So using Zapier, a paid third-party application, you can complete your request.
I am using this formula to return the month and year from a reference date, but cannot figure out how to use IFBLANK with it in order to return a blank cell if the reference date cell is empty. This is the formula I am using and trying to add IFBLANK to. =IF(MONTH([WALL DESIGN FINISH (ACTUAL)]@row) = 1, "01-",…
Hi! Thanks in advance for taking a look! I have a Smartsheet that has a line for each person being reviewed as well as their "client number". I created a helper row to let me know when each person has completed their actions, but I'm having a hard time finding a way to indicate when everyone for that client number has…
Hello, need help with a formula - I need to count within a cell range how many are NOT BLANK, this is the formula I currently have that is not working - what needs to be changed? /COUNTIF(Charter@row:[Retrospective/Lessons Learned]@row, <>"")
