-
Fx decimal place output is too much
How do I correct the formula below to show only 2 decimal places? =IF([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost $]@row < 0, "(", "") + "$" + ABS([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost $]@row ) + IF([Total (Current) Annual Cost $]@row - [Total (Proposed) Annual Cost…
-
JOIN/COLLECT - Order by most recent
I’ve configured a Smartsheet process—fed by Data Shuttle—that supports multiple activity rows per consumer. Each row calculates a unique Row ID and helper flags (Occurrences, Duplicate Entry, Duplicate IDs) and builds a Detail Key that concatenates Item, Supply Count, Date, and Person. Using these helpers, the sheet joins…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…
-
How do you create YTD formulas to track sums during a specific period?
I am having trouble creating a YTD formula to sum the total grants awarded for a given period. Any guidance would be appreciated. Thank you
-
Dashboards for comparisons from year to year
I am trying to write a formula that will compare two sheets of data, one is last year and one the current year. I want to know what items where received last year on this date and it run/update daily. If that makes sense.
-
Sum(Children()) Formula Issue
My sum(children()) formula in the first row is resulting into zero. Idk why although I tried to double check that the numbers are formatted correctly. any assistance is appreciated.
-
COUNTIFS & ISDATE FORMULA
Good Afternoon, Hope you are safe in this winter weather. MY FORMULA is unparseable: =COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")) The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY…
-
Can you make a dropdown option dependent upon another drop down? Parent / child
Hi, I am trying to setup 2 drop downs in a grid sheet. The user will select from the first dropdown (parent) A, B, C and based upon what they select i only want to show the corresponding options in the second dropdown (child). So for A show 1, 2, or 3 For B show 4, 5, or 6 For C show 7, 8, or 9 . Using a form is not an…
-
Dancing With The Stars
Hey family! I have a column with the Stars symbol. I'm using it to rank 1 to 5. While its pretty, I can't seem to quantify them. For example 5 stars = 90%, 4 stars = 70%, etc. this formula doesn't seem to work: =IFERROR(IF(VALUE(Probability@row ) = 5, 0.9, IF(VALUE(Probability@row ) = 4, 0.7, IF(VALUE(Probability@row ) =…
-
How to Phrase a Question for the AI or Write the Formula for Myself for Grouping Data
Hello, I would like to see if anyone can help me parse entries across different columns. What I have in my SS is a list of registration numbers in Column A and departmental associations in Column B. I would like to count how many different registration numbers appear in Column A and then group them by their departments in…