-
Looking for help with a formula that wont allow a selection if tow other fields have requirements
We are using Smartsheet to track system request as a PMO and Approval tracking. We have a field we select the Approver from to get this automated workflow to kick off however depending on the complexity it my require 1 or 2 UAT (User Access Testing) and want to ensure our users if one or both are required they cant select…
-
IFSUMS using word and numbers
Hello, I am building a matrix sheet to pull data from a source sheet and trying to use an IFSUMS formula, but have received various outcomes #UNPAREBLE =SUMIFS(({Evt Support Level},[Event Support Levels]@row , {Event Month}, May1)+sumif({Event Year}, 2025)) #INCORRECT ARGUMENT SET - =SUMIFS({Evt Support Level}, [Event…
-
Multiple IF formula over 2 columns
So I have a sheet with 2 columns that have numbers, text or blank. I want a 3rd column to do this, "If column 1 is blank, display A. If column 2 is blank, display B. If both columns 1 and 2 are blank, display C" How would I write a formula to make that happen?
-
IF Statements with Dates
Hi all, I am clearly missing something… I have a sheet with columns for the Start and Date Ends and then another column to track the Status (In Progress, Enrolled/Upcoming, Completed). The formula is currently: =IF([Start Date]@row > TODAY(), "Enrolled", IF([Start Date]@row < TODAY(), "In Progress", IF([End Date]@row <…
-
=IF(AND(OR(HAS Column Formula with 3 results (option 1, option 2, both) #INCORRECT ARGUMENT SET
I have a search range which is a column that has up to 35 bus routes. The bus routes are operated out of one of two facilities, "ARCADIA" and "POMONA". I am trying to create a column formula that will return a result of "ARCADIA", "POMONA", or "BOTH". I can successfully create a column formula that will return one of those…
-
Summary Sheet & Filter based on Form Responses with Multi-Select Dropdown
Hi all! Hoping for some assistance with a summary formula pulling in criteria from a multi-select dropdown response form... I have a dashboard that has a form embedded in it to allow the user to enter their desired criteria (see below screenshot) and then the bottom of the dashboard pulls in the metrics using the form…
-
If then/or /and with subtracting
Hello, I am trying to figure out a formula to subtract if Travel day = 'Yes' to subtract Submitted HRs - Lunch time, but then also subtract Submitted HRs - Lunch time - Contracted HRs if Travel Day = 'No'. Bearing in mind that Submitted HRs and Contracted HRs have formulas to get their values.
-
Date incrementing column formula works fine except in two cases.
Hi there, I am using a formula to establish future dates (Scheduled Pull-Out Date) based on a starting date (Packaging Date) and adding a number of months according to the 'Time Point' column. The formula seems to work fine until I noticed that two entries (in purple) are not following the rule; they are supposed to add 9…
-
If Function for Drop Down
Hi Im looking for a formula in my sheet where if i select a drop down in one column it will give me a selection of drop downs in another column eg column 1 - if Commerce is selected column 2 - commerce, short breaks (drop downs) only eg column 1 - if guest is selected eg column 2 - guest, guest data drop downs only thanks
-
Combine two IF formulas
Can someone kindly help me combine these two formulas? It's too complicated for the AI formula generator. :) =IF(MONTH([Global Trade Compliance Approval Date]@row ) = 1, "January", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 2, "February", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 3, "March",…