Sign in to join the conversation:
Hello, I'm trying to get my smart sheet to set the %Completed and Status columns to 100% and Completed when I check the completed box in the Done column. Can this be done? TIA.
It depends how you have your percentage cells set up. I use this for mine;
=COUNTIF([Column]2:[Column]6, "Yes") / COUNT([Column]2:[Column]6)
and format as percentage.
The % Complete column would use
=IF(Done@row = 1, 1)
and the Status column would be
=IF(Done@row = 1, "Completed")
.
Do the % Complete and/or Status column also use manual entry? If so, this will not work. You will need to either use all manual entry or automate everything. Once a manual entry is made, it will override and delete any existing formulas in that cell.
Ok. That worked. Thanks! Now the issue I am seeing is who to apply those formulas to an entire column. I'm trying to modify a template that has rows with subtasks. Is that going to be a problem?
No. You can put those formulas in the first row and dragfill down. If you are trying to use summary formulas for parent rows, we will need to tweak a few things though.
One of my team member is facing a repititive bug while entering comments on Smartsheet tracker. He has full permission on the tracker and doesnt have any internet or version issues. He is faccing this Smartsheet bug for some time where the comments are created after long set of empty pages and its hard to know how many…
Hi experts, I have a problem with a conditional formatting rule not performing as expected. I have a dropdown field called "Transit country", and multiple country options can be added from a list (not blurring out the actual options as I'm sure we're all aware of current travel concerns). I've used Contains as it's…
This discussion was created from comments split from: How can I send an attachment from a line with an automation workflow to a recipient?.
