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.
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
