-
Why would line breaks NOT present in the Report View be present in the Dashboard Widget view?
I have a field I am pulling from Salesforce into Smartsheet that has often has a lot of line breaks in it. I used a CHAR formula to remove the line breaks, and it shows correctly without the line breaks in both the Sheet and the Report. However, as soon as I pull the report into a Dashboard widget, line breaks appear…but…
-
FORMULA WHEN THERE ARE MULTIPLE LINES IN A CELL
I have a sheet that has some rows that have multiple lines. I want to use the qty from each line for a summary formula. I have a formula that works when there are only one line in a row, but I get an error when there are multiple lines. Anyone know of a way to do this?
-
Countif date is more than 5 days ago but less than 7 days
Struggling with this and I'm not sure why. I want to gather a count of Opened Events that were initiated more than 5 days ago but less than 7 days ago. So I want a count on all Events that have a Date initiated that is 5 or 6 days ago but nothing beyond 7. Thank you in advance
-
How to fix adding 1 or -1 to date difference calculations
Hello, I'm trying to set up a formula which will calculate the difference between two dates to achieve a days overdue number for our orders. Current formula is: =IF(Status@row = "Delivered", NETWORKDAYS([Delivery Date Expected]@row, [Delivered Date]@row)) This is returning an almost correct result, except it always adds a…
-
Tracking Missing Submissions
Hi! Thank you for considering this problem, I am very new to Smartsheet. I have a form that I have 10 regions complete monthly. There is a due date for each month. I would like to generate a report of those of the 10 regions that did not submit a report monthly. How would I go about doing this? Thank you again!
-
I need help with a SUM(DISTINCT(COLLECT formula
I am trying to sum the amount of opening in the Openings column for distinct REQs if they have an approved date of January. I keep getting the #invalid operation formula error. Here is my formula =SUM(DISTINCT(COLLECT({Openings}, {REQ}, {Date Approved}, MONTH(@cell) = 1))) Please help
-
Cross reference match formula
I am looking to cross reference Sheet A to pull in Time slots from Sheet B. Criteria I need to have matching from Sheet A to pull from Sheet B to determine the slot number or multiple numbers. Start Time End Time There could be multiple Slot Numbers so it would need to be a multi option that I could use later to separate…
-
Trying to calculate the number of submissions
We just ran a survey in Smartsheet using forms, and its going through the next 2 weeks, i want to gather how many we have received from our survey document and display it on my metrics, to then display it on a dashboard. What formula would I use to do that? I was doing some research but i just keep getting #UNPARSEABLE
-
Multiple nested IF(AND) paired with INDEX/MATCH ? or other way ?
Hello to everyone. Im starting to go deeper into advanced formulas and sheet reference, but have some issue... I have a "customer activity" sheet, where for each line, there is 2 sets of variables (5 in "activity", 3 in "types"...) and a "Duration" column. I would like to compute the "Final Price", by referencing a "price…
-
Formulas not working after adding year?
I'm getting one of our dashboards updated for the new year but the previous year didn't have the year part of the formula. I've gotten it added for most but I've run into a couple where when I add the year piece I can't seem to get it to work: =COUNTIFS({Relevant #}, 1, {Submission Date}, IFERROR(YEAR(@cell ) = 2025))…