Formulas
Discussion List
-
Automated Move Rows won't move anythingIn Formulas and FunctionsI have an automation set to run whenever a "Status" row changed (or row is added) with a condition: "Where Status Contains 'Out of Service'". It's set to alert me, then move rows. It alerts me just fine, but won't move …
-
Counting one column when criteria from another column is metIn Formulas and FunctionsHi! I would like to count the number of cells in one column that is not blank when another column is "HR" or "SURVIVOR". My current formula is below and is returning a #UNPARSEABLE error. =COUNTIFS([APP./RETURN DATE]:[…Answered - Pending Review 20 views 7 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
How do I calculate a formula to alert 6 months before a travel date from a passport expiry date?In Formulas and FunctionsI'm lost for creating a formula to create an alert from 6 months before a travel date (column labelled): Trip Start Date (office) from a passport expiration date (column labelled): Expiration Date by highlighting the Expiration date (YELL…Answered - Pending Review 14 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
In need of formula to check box using based on data from 2 columnsIn Formulas and FunctionsMy best try was: =IF(AND([To Be Filed]@row > 0, 1, [Days Since Close]@row < 60, 1)) Got any ideas?
-
Status If/And FormulasIn Formulas and FunctionsI have a project manage sheet I'm managing that I can't seem to get the formulas right in. The first one has two parts. 1) I want the status to be green if the Planned Completion Date is equal to today or the future. The Status to be Yel…Answered - Pending Review 24 views 1 comment 0 points Most recent by Krissia B Formulas and Functions
-
Help with Trend DataIn Formulas and FunctionsI need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. …
-
Combining IF statementsIn Formulas and FunctionsHi Smartsheet community, I am currently trying to create a formula, that states if Updated Completed Date is blank then use the date in Original Completion Date column but if not blank then use the date in the Updated Completed Date column…
-
Lookup text and calculate values in cells from columns in the same rowIn Formulas and FunctionsThe formula I'm using for this is working, but it feels like it could be completed in an easier way. I want to look up the text "Grand (Total)" from the Rows column then divide the numbers from the Audits and Findings columns in …
-
Adding up only the numbers that meet a specific criteria in another columnIn Formulas and FunctionsAs stated in the titled above, I am trying to figure out how to do a formula that adds certain numbers together in a column, based on if the text in the column next to it, on the same row, is a certain value. Example - Add Column B's Hou…
-
How do I add another IF statement to a Workdays calculation?In Formulas and FunctionsI am using the following formula (from a template) top calculate Working Days Remaining for a task - =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) However, I want to add a condition…
