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.
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
