Formulas and Functions
Archives for June 2021
Discussion List
-
How do I change a cell value to a symbolIn Formulas and FunctionsIn the automation 'Change cell value', is there a reason that symbols are not included? I want to use the symbols, but base on the response from other team members. The responses are being asked from a Drop Down menu, but I cannot get the …
-
Auto Delete Data in SmartsheetIn Formulas and FunctionsIs there a setting in Smartsheet that will allow me to auto delete data after 30 days?
-
How to create this COUNTIFS with AND/OR/NOTIn Formulas and FunctionsI cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "…
-
Count if Column has a dateIn Formulas and FunctionsI'm trying to build a ship status sheet and use the sheet summary to give me a count if a certain column has a date. something like: =COUNTIF([Estimated Ship Date]12:[Estimated Ship Date]22, (ISDATE(, "1", "0")) but all…
-
Forumla help plsIn Formulas and FunctionsHello, I'm trying to create a dashboard or even a simple sheet that will pull data from my main sheet. Essentially I have a master sheet with Merchant info, Sales Person, Payment Status, and Application status(done or 1of 5 other statuses)…
-
¿Hay manera de distinguir si una fila es subtarea o no?In Formulas and FunctionsQuiero que en una columna se muestre un icono sólo si la fila no tiene subtareas ¿es posible con una fórmula? Gracias
-
How to keep a cell blank if there is no data?In Formulas and FunctionsI have two sheets a master (2800 records) and a feeder (270 records). I am using the following formula to update a column called scheduled date on the master: =INDEX({feeder06262021 Range 1}, MATCH([email protected], {feeder06262021 Range 2}, 0)) Wh…
-
Formula for Payment Terms "Net 10 EOM"In Formulas and FunctionsI'm trying to write a formula to calculate a payment due date using the payment terms "Net 10 EOM". Meaning if invoice is submitted by the end of the month, its due by the 10th of the following month.
-
Combining multiple criterias with countifs and hasIn Formulas and FunctionsI would like to simplify my formula =COUNTIFS({WK 24 Range 1}, HAS("5:00", @cell), {WK 24 Range 2}, "") + COUNTIFS({ WK 24 Range 1}, HAS("5:15", @cell), {WK 24 Range 2}, "") + COUNTIFS(WK 24 Rang…
-
Lost with vlookup or matching?In Formulas and FunctionsI am needing to update a Smartsheet to reflect the date listed in a cell from another Smartsheet. Both sheets have an IP address that can be match on as there are no duplicates. The feeder sheet with the date has 210 entries and master she…
