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…
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.
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…
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…
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…
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!…
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…
I am looking to Create a cross-sheet reference formula that meets multiple criteria. see screenshot
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
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"…
