-
AVG and COLLECT
I have a large data set that I need to average one column but based on 2 criteria. I've got the formula working for one of the criteria but am unsure how to add in the second one. Scenario: Metrics for year to date; columns for Dept (ITDept), duration of ticket (Duration) and the month that the ticket was closed (Month). I…
-
Convert to Column Formula
I am adding a simple "IF" formula to a field, but when I convert to entire column, it erases all the values on the rest of the fields in that column. This doesn't make sense because the other values that are being erased are not related to the "IF" formula I am creating. Is there a way to apply a formula to an entire…
-
Need to get a stacked formula
Hi everyone - please excuse me if I type this incorrectly, this is my 1st time attempting to get assistance I have the following formula that appears to be working: =IF(ISDATE([executed date]@row), IF(YEAR([executed date]@row) = 2021, SUMIFS([amount nte]:[amount nte], [formula - Year]:[formula - Year], "2021"))) I am…
-
Multiple Conditions
I need to automatically change the values in a Date field to "N/A" whenever BOTH of these criteria are met: column A = "SOW" Column B is greater than "$200,000.00" Can you please help?
-
Formula Assistance
I'm trying to create a automated system in Smartsheet's that takes criteria from a form submission (Unit, Start Date, End Date, Day of the Week and Shift time) to cross check another Smartsheet that has the full calendar year by week and if all criteria from the submission match on the calendar sheet for the…
-
Formual for summing/counting
I have a running sheet that tracks the date for a review. The basic sheet has Location, District, ReviewDate, Available_to_Review. I need the column to be a calculated field that give me a Y/N or 1/0) for every record. The criteria would be if a Location has had a Review Date in the last 30 days, the Available_to_Review…
-
Automation
I am trying to create a trigger that sends out an email 4 months before. I only see an option for 30 days, 60 days, 90 days, 180 days, and 365.
-
COUNTIF/FIND/OR in multiselect column
Im looking for help using or in searching for any of the values in a column. Original/reference Column with multiselect where I am looking to find any instances of the sub category. Attempting to count number of instances of any of the selections: Current attempt: =COUNTIF({1 | Neuroscience PPM Range 1}, FIND(OR(@cell =…
-
VLookup Question
Hello, I am looking to compare two sheets each month. I have VLookup searching for 4 individual pieces of information from the Monthly Sheet within the Master List: Employee, Merchant, Date, Amount. Currently, I have =VLOOKUP(Employee@row, {Master List Name}, 1, false) that looks for the Employee Name and will either…
-
Error on formula
=IF([Assigned To]63 = "Yes", "Not Started", "Complete", IF({Submittal Log - MCCO Fence Repair Range 2} = "Approved", "Complete", "In Progress")) Trying to string 2 if statements together am I on the right track? Not sure if I need an AND statement maybe. this produces incorrect argument set. Thank you for any insight on…