-
Auto Delete Data in Smartsheet
Is there a setting in Smartsheet that will allow me to auto delete data after 30 days?
-
How to create this COUNTIFS with AND/OR/NOT
I 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 <> "Complete"), {(Phoenix) Project Tracker - Status column}, AND(@cell = "Complete"), {(Phoenix) Project Tracker -…
-
Metrics Sheet Pulling from Reports
Hello All, I'd love to know if its possible (or a workaround) for creating a metric sheet to use in a dashboard using data from reports. We have 90+ Sheets that we can easily pull data into a report but its hard to get that into a meaningful chart. One specific example is we have 90+ sheets with rows that contain a rating…
-
Count if Column has a date
I'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 i can seem to get is UNPARSABLE
-
Forumla help pls
Hello, 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). I want to pull data from my main sheet so it's easier for the Sales team to quickly…
-
Is there a way to distinguish if a row is subtask or not?
Quiero que en una columna se muestre un icono sólo si la fila no tiene subtareas ¿es posible con una fórmula? Gracias **Google Translate by Moderator** I want an icon to be displayed in a column only if the row has no subtasks, is it possible with a formula? Thank you
-
How to keep a cell blank if there is no data?
I 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(IP@row, {feeder06262021 Range 2}, 0)) Which works bringing the date in, however the majority of the cells on the master sheet…
-
Formula for Payment Terms "Net 10 EOM"
I'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 has
I 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 Range 1}, HAS("5:30", @cell), {WK 24 Range 2}, "") + COUNTIFS({ WK 24 Range 1}, HAS("5:45", @cell), { WK 24 Range 2}, "") Is there a…
-
Lost with vlookup or matching?
I 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 sheet has 2800 entries. I want to copy the date field from the feeder sheet to the group…