-
COUNTIFS with OR
Hello, I have spent hours trying to figure out what I am doing wrong, but I cannot seem to figure out what would get this formula to work. I am trying to count if my Simulation column says Phillips, the complete checkbox is checked and Type is Pilot OR Simulation. The formula works fine up until I add in the Type being…
-
Total Site % Complete + health
I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s say, Milestone ABCDEF etc I just want to SUM all the milestone % complete to give me the total project % complete Then the…
-
TOTAL% COLUMN
-
How to retain monthly calculated counts of projects in certain statuses?
We need a way to provide counts of projects in various statuses each month through a calendar year; for example...how many projects were in progress in the month of Jan, how many projects were completed in the month of Feb, etc. I have a column for each month in a calendar year and rows representing the metrics we need to…
-
Grab the numbers in a cell to another column then get their average. Substitute, AVG not working
I need to get the TC values only and then get their average (to be place on sheet summary). But it appears that when you try to use replace or substitute, it is converting them to text. Value and INT can be used, but I tried both and its not working for my sample.
-
How to overrule a 0 multiplication formula returning 0 as an answer?
Hi all, haven't been able to find anything on this by searching so I'm posting. I'm hoping it is a simple fix as the formula seems very simple! I am attempting to calculate accident frequency rates at my company. I fully understand that anything multiplied by zero returns zero. However, if there have been no accidents I…
-
cross refference formula that meets multiple criterias
the problem i have is that there are 2 spreadsheets used by 2 teams, but both should have the same info. in the screenshot, i displayed the different scenarios. I can keep it simple and have returned a MATCH or NO MATCH. The goal is to have the formula return with a value that indicates where the discrepancy lies. if sheet…
-
SumIFS Formula Issue
Hi I need to count the number of total Artefacts if the Process column equals one of four process options. I'm doing this calculation in the Sheet Summary function and I've followed the help guide to set up the formula but I'm still having issues. Here is what I have: =SUMIFS(Total # of Artefacts:Total # of…
-
Text to columns delimited by # character
Hi, I have a column I need to separate from 1 column into 2, delimited by the # character. The output (new column) is consistently 6 characters, but the amount of characters preceding the # always varies. I know how to do this in Excel but would love do this with a formula in Smartsheet. Thanks for any tips in advance!…
-
Struggling with IFERROR syntax in nested formula
I've finally gotten this INDEX/MATCH formula to search 2 sheets and return the correct result but I'm struggling with the IFERROR portion. I think I need a second nested IFERROR. I would like the cell to remain empty if no result is found instead of the #NO MATCH result that currently appears. =IFERROR(INDEX({Clinical…
