Formulas and Functions
Archives for February 2021
Discussion List
-
I need a formula for a reportIn Formulas and FunctionsNeed a count if formula and sum if for to look at certain sheet and populate another sheet: EX. If I have a row that has a cell with certain name like Event1 then has appt set checkbox and sales amount I want to count how many appointment …Answered - Pending Review 17 views 3 comments 0 points Most recent by Kelly Moore Formulas and Functions
-
COUNTIFS FORMULA with Cross Reference and MONTH DateIn Formulas and FunctionsI would be most appreciative for help on this formula. I am cross referencing data from another sheet and trying to count how many times TM & AM pop up in the month of February. I keep getting the UNPARSEABLE error. =COUNTIFS({GCS S…Answered - Pending Review 70 views 4 comments 0 points Most recent by Kelly Moore Formulas and Functions
-
How can i have a cell that shows an amount from another cell if its 30days past a date in another ceIn Formulas and Functionsrow 1 date billed row 2 dollar amount row 3 dollar amount past 30 days Row 4 dollar past 60 days Row 5 Dollar past 90 days =if( row 1 is less then 30 days) show row 2 =if( row 1 is less then 60 days but greater then 30 days) show row 2 =if…
-
Cross Sheet Reference FormulaIn Formulas and FunctionsI am trying to write a cross reference sheet formula to count MTD dates in a column using this formula I found here but it is not working. Thoughts? =COUNTIFS({Andee Metrics Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MON…
-
Excel Form. works well but not in Smartsheet =COUNTIFS(Q:Q,"<>*/*/*",Q:Q,"<>",Q:Q,"<>Complete")"In Formulas and Functions
-
formula like MAX, but that grabs the top three?In Formulas and FunctionsI have a sheet that collects project updates per project, and I want to surface the most recent three updates per project for a report. So the data is really simple, there is a date and an incrementing autonumber, so I can use either of th…Answered - Pending Review 17 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
Trying to get a list of distinct values across multiple columnsIn Formulas and FunctionsHello, I have a list of providers. Each provider can list up to 4 languages spoken at their office. I would like to get a list of distinct languages for the entire list of providers. Language 3 and Language 4 have different languages fur…Answered - Pending Review 158 views 6 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
SumIF Cross SheetIn Formulas and FunctionsI am simply trying to summarize AR data for a dashboard on a summary sheet. I need to know the balance due for each company totaled up. Below is one of many attempts I have tried. There are only six options so I canmanually update the fo…Answered - Pending Review 11 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Set the Current Date with Record a Date ActionIn Formulas and FunctionsHow can I set the automation so that it only records a date in the row that is being updated? At the moment it is updating every row in the sheet when a single row is being updated. https://help.smartsheet.com/articles/2481986-set-the-curr…
-
Status Roll Up FormulaIn Formulas and FunctionsI am working on a sheet to track the status of test cases and want to have the status of the subtask roll up to the parent status. The goal is that if 5 tasks are available and 2 "Passed", 1 "In Progress", 1 "Not S…Answered - Pending Review 144 views 2 comments 0 points Most recent by Daniel Melton Formulas and Functions