-
Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard
There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our dashboard results. Any help or advice anyone has is welcome. Thank you!
-
How to get top 5 most caused services from countifs roll-up by month
I work for a bath remodeling company and we want to track the top 5 reasons we have services from our service calendar in Smartsheet. I created a COUNTIFS roll-up formula that is below and located in the children rows below Top # 1 Service from pic: =COUNTIFS({Nature}, $Label@row, {Month}, INDEX(ANCESTORS(), 1), {year},…
-
If AND or OR formula
Hi Experts, I would like to extend my formula in column Tech Pack confirmed on time. It works well with the color balls. =IF([Dev sample needed?]@row = "", "not needed", IF(AND([CAD upload on time ?]@row = "Green", [Pattern confirmed on time?]@row = "Green", [Tooling confirmed on time?]@row = "Green", [Materials confirmed…
-
Checklist workflow automation
I'm trying to convert a onboarding checklist into an automated workflow. For example. Role X has tasks 1, 2, 3 associated with it. Role Y has tasks 1,2, 6,7 associated with it. I would like the tasks to auto-populate based on the role. It would also be great if I can notify people when it's time for them to work on their…
-
Index/Collect with a date being one of the criteria
Hi, I'm trying to write an index/collect formula and one of the criteria is that the date is yesterday. I'm having trouble. Any suggestions? =INDEX(COLLECT({Evergreen Totals}, {Admission Type}, "Start of Business", {Date}, TODAY() - 1, 1)) Thank you!
-
Formula not working in Smartsheet when data is populated from form
I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form. Thank…
-
Generating dates based on dropdown choice in another cell
Hi everyone, I'm very new to this and trying to generate a formula that will calculate deadline dates based on dropdown choices in another cell. If we get customer queries by phone, we have a deadline of 2 days' resolution; if we get them by email, it's 10 days. I would like to be able to auto-generate deadline dates for…
-
Simple COUNTIF Formula Suddenly Stopped Working?!
Hi I have had a very simple countif formula, that has been working with no problems for months, suddenly start retuning a #INVALIDOPERATION error. I have reviewed the formula and can't see anything wrong with it, has anyone else had the same issue? Have Smartsheet released something and broken this? TIA
-
#NO MATCH error
Hey everyone! I seemed to have ran into an issue using a vlookup formula. When I first wrote it out it worked for that cell but when I dragged it down the whole column it no longer worked. =IF(VLOOKUP([H145 A/C #]@row, {QG Schedule Tracker Range 4}, 2) = "Not in SS", "No", "Yes") This checks if the aircraft number in that…
-
sumif with children
Hey everyone I am trying to set a formula that I believe should work but keep have an error returned. What I'm trying to achieve is in the box that says #unparseable I want it to sum the numbers below it only if the status column shows Approved. I want this to happen in perpetuity for any children rows that are added below…