I'm requesting help to create a formula that will calculate the % of the checked boxes that are checked vs unchecked for calendar year with a project status of complete?
You could use a COUNTIF formula to count all the "Complete" rows.
Then you could do two other formulas, each a COUNTIFS formula (plural, for the two criteria), that counts if the box is checked and if the status in that row is "Complete".
Then you divide the result of that formula from the original count to get the percentage of each, and compare.
You could combine the first count with the second to build it in one formula, but I would suggest to start to do three separate formulas, then calculate your percentage separately from the results, as it will give you a better overview of counts as well.
Here are the Help Center articles for both functions: COUNTIF function / COUNTIFS function
If you need help creating these, it would be useful to see a screen capture of your sheet with the column names (please block out any sensitive data), as well as specifying if you want it to be a cross-sheet formula or in the same sheet (perhaps in a Sheet Summary field, if you have this capability?)
Thank you, I was able to get it to work with the CountIfs.
Awesome! Glad to hear it :)
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
Hi Guys, I am looking for the formula to return value for a cell which is in the range. I have one smartsheet like above in the second smartsheet I have cell with date and for example if I have there 08/02/24 I want formula to give back Q3 FY25. Any ideas how can achieve this?
We have a daily task at the beginning of the day in which the first thing to do is to review and track the number of tickets accumulated outside of working hours from our system. The timestamp column comes from the system with the format "datetime", in another separate Smartsheet we are trying to show the date on the top…
©2024. All Rights Reserved Smartsheet Inc.