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.
How to export Smartsheet project plan to a PowerPoint slide without using any other paid app like Office-timeline pro+ etc. Is there a connection between Smartsheet and PowerPoint through simple export option or some such integration.
I accidentally deleted the wrong spreadsheet I looked on the site and it says that I can recover it and the deleted the items tab but I don't have any options on my Smart sheet app or web.
Hi, I have five Smartsheet accounts—four with editor access and one admin account. Recently, I’ve been unable to log in to one specific editor account. It shows the message “Too many failed attempts. Try again after one hour or reset your password.” However, I attempted to log in only twice, and the error appeared on the…
