I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
Hi there!
I am fairly new to Smartsheet as well and I used logic similar to excel and did a countif and then divide it by a total count. I used checked boxes for each step and it would update my % Complete for me.
Here is the formula that I utilized, but there might be something simpler that I am not aware of.
=(COUNTIF([Scope Complete]2:Done2, <>0) / (COUNT([Scope Complete]2:Done2)))
Good Morning,
I just tried it and it is not working for what I am looking to do I have target date and completion date. When I change the information in the formula tabs it comes up with the Unparsable error
I wasn't using dates -but you could create a column that gives you the total days and the total remaining days based on the target. I am sure you could do this in a formula as well. My formula was looking to see if multiple columns were greater than 0.
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
Hi - we are performing an audit and we need to take the data, and have the consumer validate that its accurate, and if not, identify the change required. What's the best way to tackle that? I was thinking a form but there could be lines and lines of data to validate; is it as simple as having them review the sheet for…
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
