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, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
