-
Concatenate formula to combine Date and Time into unique code
When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. How can get the Concatenate formula to just reproduce the Date format…
-
Track unaswered questions
Hi guys I have a list of questions and the only answer expected is Yes or No from the dropdown. I want to track All unaswered questions, if it is blank i want the editor to see 70% Incomplete or 3 questions not answered something like that. All questions in the sheet don't change, see the sheet - Handover document…
-
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