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.
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
