-
#INVALID OPERATION Error
Question: Is it possible to write a SUMIFS column formula to add up specific cells in an adjacent column where the criteria are also in other adjacent columns? (Actually, I know it's possible, because the formula I wrote a couple days ago worked just fine at first, but it's refusing to work today, and I don't know why. The…
-
Search on a text string to return all values
Hello My Fellow Smartsheet Gurus, Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match is not always possible? If so how would accomplish this? Thanks so much in advance!…
-
Countifs OR Formula Issues
I am doing a countifs formula, and am unsure how to include an OR formula. In the Summary Program column located on another sheet, I want it to count the number of both Bi-Annual and EMEA cells. for rows which Summary Season is S21 This is the formula I have used that resulted in an Invalid Operation error.…
-
Formulas for % Allocation in Resource Manager
Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on it and haven't found a straight answer yet, but it seems as though having a formula…
-
Why are Round function irregularly displayed in dashboard
When I use a Metric widget in a dashboard, add data (Rounded) from a Grid is sometimes displays the rounded numbers, but the next, without modifications, it doesn´t.
-
Collecting Dates in a Reoccurring Approval
I have a sheet that needs to be reviewed and approved by multiple individuals on a regular reoccurring basis. I have already set up the workflow for this to happen but I will need to keep a list of the dates they were previously approved. Is there a way to use a formula like Join/Collect to do this? When I try it will just…
-
Countif, Collect, index
I'm trying to count all installations for a site from the master grid sheet to a new grid sheet. The formula I created only brings back two records for each site. =COUNT(INDEX(COLLECT({**Master Grid "installed" column** - Store Install Schedule Range 7}, { **Master Grid "Store#" column** - Store Install Schedule Range 5},…
-
Sum if unique names only
Hi there, I have a rollup sheet that adds the amounts if the names are unique. I get the names with a vlookup formula to get them from the source file. The source file has the names entered multiple times but their amounts are the same. I identify unique names with a formula that places the #1 in the column CountUniques.…
-
Formula with range that goes from a certain row to whatever the current bottom row is
My formula: =AVG(COLLECT(IIQ28:IIQ99, [SE Manager]28:[SE Manager]34, "John Lennon")) First, I cannot use the entire column. There is data in rows 1-27 that can not be applied to my average. I want the range to go all the way to the bottom of the sheet, because this sheet is regularly populated by a workflow from another…
-
Continuously evolving Sum formula
Is it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul and Aug. The rest of the year is mapped in the exact same style, but for Sep Oct Nov and Dec.…