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.
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
