Formulas
Discussion List
- The Smartsheet above is referenced by multiple members of my organization, but I'd like to simplify some of the information for the members who only want to know specific metrics. I've obscured inform…
- Hello Smartsheet Community, I'm struggling with something that I guess should be a very simple formula. I need to assign one of 3 values to the row based on the following rules: If Cutoff Date > Event…
- I saw this article - https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/ however, I am not sure where these functions are at. Any help on how to merge data from multiple cells like they a…
- In Smartsheet for my percentage column it is only showing me a count when highlighted not the % avg. When I am trying to pull this data to other reports the formulas come back # Divide By Zero but the…
- If Status on the parent is marked qualified it will fill all the tasks below for this section only qualified. Which will stop all the alerts. How do I make it so it only affects this drop down and now…
- Good Evening Community. Trying to count an item that meets certain criteria. For example I am referencing two columns of the same sheet and trying to count the first column that contains Food POS and …
- Hi All, Trying to work with Created Date column to extract the time from Time Stamp, then look at the time to determine if it falls within two statuses. This is for a Rush Payment Cutoff Time. If an e…
- Good afternoon community, I'm in need of help with a formula that I feel has come close, but still just off of the mark. I have three sheets: The first is holding static data (Inventory Cost sheet). T…
- I have a few formulas on the top 3 rows of my sheet that are KPIs for the sheet. Since they consume the top few rows, I cannot select the entire column in the formula or it returns an error of Circula…
- Hi, I have the below matrix, is there any easy way to get the formula to do the various risk levels (low, medium, high and extreme)? I have attempted to try with AI the formula but for some reason sta…