-
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…
-
Create a cross refference formula that meets multiple criterias
I am looking to Create a cross-sheet reference formula that meets multiple criteria. see screenshot
-
Using checkbox to add value in another cell.
I am not an expert on excel but I am trying to add value (more specific: adding date/time or just time automatically) to another cell just checking a check box cell. Is this possible on smartsheet? Thanks. Al
-
Linking checkboxes across 2 sheets
I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data. I want to link a checkbox when any end of day report has a "Install complete"…
-
CountIfs Invalid Ref
I cannot for the life of me get this CountIfs function to work. Referencing another sheet. Plz help! =COUNTIFS({FY23 PWP Meets Objective:Meets Objective}, "No", {FY23 PWP PHC:PHC}, "FFH") Screenshot of my reference sheet columns and values.