Sign in to join the conversation:
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.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
