-
Combining Formulas
Can someone please help me combine these two formulas i cant figure it out. =SUMIFS({Dev Fee}, {Site Status (Dashboard)}, OR(CONTAINS("Live", @cell), CONTAINS("Completed", @cell), CONTAINS("Exchanged", @cell), CONTAINS("HOT's Signed", @cell) {Forecast Shovel Ready}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0)…
-
Can Character limits be added to text fields, specifically for a form?
I saw the post from 6/18/21 here: https://community.smartsheet.com/discussion/80492/can-character-limits-be-added-to-text-fields However, the formula =IF(Text@row >= 50, "Limit Reached. Please use less characters") is creating an #UNPARSEABLE error.
-
JOIN DISTINCT COLLECT *DESCENDANTS*
Hi, I am used to using this formula: =JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), <>"")), CHAR(10)) to roll up unique children but have replaced the 'children' with 'descendants': =JOIN(DISTINCT(COLLECT(DESCENDANTS(), DESCENDANTS(), <>"Total")), CHAR(10)) but it's returning both children and descendants? I only want…
-
Condition formatting - Priorities
I'd like to add condition formatting to cells on a sheet which show items in the next 7 days as one color. And Items in the future as another. Unfortunately the higher priority format ( in the future) cancels the (in the next 7 days) is there a way to make this work please? Thanks in advance
-
Formula issue
Hi Have built this formula I need to return a "High" symbol if my DD helper Column is greater than 10 working days, a "low" symbol if < than 10 working days and if the DD helper column is blank then return blank - but i am getting an error DD 10 Day helper column is set with a record the date automation - when the status…
-
RGY Health Formula for Status and Due Date
I'm struggling to complete a formula to do the following: If Status is Complete, mark the health green. If Status is Not Started or In Progress and End Date is 10 days or greater, mark health green If Status is In Progress OR Not Started and End Date is within 5 days, mark the health yellow If Status is Not Started OR In…
-
SUMIFS Formula not working
= SUMIFS({2024 Expenses | Total Expenses}, {Staff Name | Name}, Name@row, {2024 Expenses | Type}, "STAFF - Medical", {2024 Expenses | YYYYMM}, YYYYMM@row, {2024 Expenses | Status}, "Approved") Sheet 1 2024 Expenses: (While Staff Name sheet is another sheet where we kept all Staff Name Details) This is currently my formula…
-
Collect Latest Score given date, name & score data
Hi I'm trying to collect the latest score for a given customer into my metrics sheet for my dashboard. The Metrics sheet looks like this: The source collection sheet (fed by a form) looks like this: There are hundreds of customers, and all scores are in a single column, help would be great - thanks in advance, M
-
Help to select a value based on row number
Hi all - I am trying to determine if a task is ready to start based on all of the predecessors being 100% complete. I have numerous tasks with more than 1 predecessor and I've parsed out all the predecessors into individual columns (pred_1, pred_2, etc) like this I'd like for the ready to start column to indicate yes, if…
-
INVALID OPS, REFERENCE AND BLOCKED Issues
Hi, we are experiencing a TON of issues in our smartsheet documents and I have no idea where to begin with figuring out how to figure out where and what went wrong. The person who built the smartsheets from the beginning no longer works with us. Could someone please help? This is not the only spots this is showing but…
