-
Added 2 years to date, only want to populate in specific fields
I have created a calculation to add 2 years to a specific date listed in a field, but I would like to create a formula where it calculates the 2 year date but only populates if the other field is filled in. Current formula: =DATE(YEAR([PO Date]@row ) + 2, MONTH([PO Date]@row ), DAY([PO Date]@row )) If the PO date is fill…
-
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.…
-
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…
-
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…
-
Calculating Time in Smartsheet
Hello. In excel, I have a formula that calculates the departure time of a coach from point A by taking the arrival time (a variable I choose) and subtracting the travel time. I then have a formula that subtracts 15 min from the departure time for the load time. The final formula subtracts 15 from the load time for the spot…
-
Date Based Automation Did Not Send Automated Email
We have a date-based automation that sends an automated email to our employees. The automations trigger is "When a date is reached" and that date is the date in a specific cell. The date in the CLIN 2 First Reminder cell is a date that is calculated by a formula. The formula looks at the hard-coded date in the CLIN 2…
-
Automating Email Alerts for Multi-Stage Document Review
Hi, I’m looking to set up email alerts for two stages of a document review. I’ve currently configured IF functions so that, once the ‘Document Received’ checkbox is selected, the status in the ‘Primary Review’ column automatically changes from ‘Not Started’ to ‘In Progress’. Stakeholders then tick off the relevant boxes in…
-
COUNTIF & ISDATE FUNCTION
Good Afternoon All, I hope you are stating safe in this winter weather. I have a formula but to no avail I am getting unparseable. I want my COUNTIFS function to count only if there is a date in column (DEACTIVATE TIMESTAMP YR 5) = ANY DATE and count only if the specific criteria from on column (DEACTIVATE TIMESTAMP YR 5)…