-
SUMIFS not in the same sheet
Hi All I am having a tricky time with a SUMIFS formula that is not in the same table as the data. I can get it to work within the sheet; =SUMIFS([Total Recommendations]1:[Total Recommendations]45, [Allocated Senior Auditor]1:[Allocated Senior Auditor]45, "Auditor Name", [Senior Status Complete]1:[Senior Status Complete]45,…
-
Track Who Completed an Item
I am trying to track who actually changes a dropdown to "Completed". I know I can check individually using the cell history, but I need an easier way to monitor who is completing which tasks without having them update the field manually. I have a contact list column I can use for this, but I can't seen to get an efficient…
-
Percentage of a number within a cell
In Excel, I can utilize the following formula to find the percentage of a number. Input =H5*30.1% Output $11,371.11 When H5=$37,777.78 However, in Smartsheet, the formula does not copy over and when the formula is manually entered in Smartsheet, it tells me that it is unparseable. Manually doing the calculation defeats the…
-
Update Cell if A Different Cell Changes
Here is my problem: Column A has dropdown values: Open, closed, pending, approved Column D has dropdown values: Approved, Deferred, Escalate I created a helper column and what I'm trying to do: if column D change to approved, column A will also go to approved If column D changes to escalate. column A updates to approved if…
-
Replicating filtered column data between sheets?
Is there any way to essentially live link a column between sheets? I need to pull in a few distinct columns from a sheet with close to 100 columns, then sort the data and graph it. I've been trying an IF/AND statement, but I keep getting unparseable errors. =IF(AND({Complete %}@row < 1, {Order Vs Project}@row = "Order"),…
-
Hello, I am trying to generate a formula that would help with the following:
I have projects that have a weekly status statement box that PM's edit every week with new project information, below this cell is another cell that has the status statement updated date...we have a problem with PMs filling out the date so I would like the date cell to automatically change anytime someone makes an edit in…
-
COUNTIFS with multiple designations
Good afternoon, I'm trying to use a single column to determine all "Active" sites in a given county, which would include several designations in my "Tower Status" range, including "Pre-Planning", "Construction", etc. I have the following formula, to find the count of any one designation, but how would I add "Construction"…
-
COUNTIF Exclude
I'm trying to exclude a column that has item checked with a checkbox from a result, but I'm getting an UNPARSEABLE error. It works fine until I add ", NOT..." Any guidance would be appreciated. =COUNTIF({Resource Request with Range 2}, [Primary Column]@row), NOT({Resource Request with Range 3} = "is unchecked")
-
I need help with a formula to determine the number of days a certain criteria has appear in a table.
I am new to smartsheet and trying to help our quality team. I need a formula that will count the number of unique days that an auditor has entered audits. I have one sheet that is the complete database with an automatically created date for every audit and another row that list which auditor created the entry. In another…
-
Average with certain criteria in other columns
I am trying to create calculate the average for each person but only for rows that are greater than 11/30/20.
