-
Running a report - Keeping old data to compare
Hi Team, I want to set up a report that will allow me to pull values from a column at a certain date/time, then within that same report, for that same column, pull the values a later date/time so i can compare changes. Is this doable? When i create report and link it up to the columns i want, it is all live. So if someone…
-
In need of formula to add multiple durations together from one sheet into one cell on another sheet
I have a list of hundreds (thousands) of rows of data, most of which have one duration per unique identifier, but on occasion, there are multiple durations (usually never more than 6) for the same identifier. I need a formula which will compare the identifier on Sheet A to the identifiers on Sheet B and either: If only one…
-
Contact List not Populating
Hello, I have created a form with a couple of fields that have the Field Type set to contact list, but when testing the form nothing populates in the field, it's as if it was set to text / number. Is there a way to have it auto populate as a user begins to type a name? Thank you.
-
Count Items from Another Sheet that Contains Partial Text
Good Evening, I am trying to count different ticket types from another sheet in my smartsheet workspace but for some reason am unable to figure this out. Below is what I am attempting to do and I hope this forum of experts is able to help. In the sheet below I have a column ticket info. This column will list all tickets…
-
Index Match - Returning a blank Value
Hi All, I am working on using an Index/Match to pull physician email addresses based on their EMP CID, which is stored on a separate physician roster sheet. =Index({Physician Roster 2024 Email}, MATCH([EMP CID]@row, {Physician Roster 2024 EMP CID},0)) When adding a physician to this sheet, if I leave the EMP CID field…
-
What could be causing inconsistent formula result?
I'm calculating HH:mm using the following logic & getting inconsistent results for the minutes calculation. The formula is the same for all three scenarios, but the Current Year Delivery is multiplying the minutes by 100 compared to the others. All the source data is consistent. What am I missing here?
-
Checkbox Question
Hello, I'm trying to make a formula so that when my "Task 100% Complete?" column checkbox is checked then it will automatically change "Fab Status % Complete (Needs Real Numbers)" column on that row is changed to 100% automatically. This saves the user of having to check the box and change the Fab Status column to 100%…
-
Using COUNTIF/COUNTIFS with OR statements
If I want to do a row count, where if Col1= 4 or 5 OR Col2 = 4 or 5, what is the best way to go about this? So for the example below, the count is 3. Appreciate any help. Thank you.
-
Is there any formula to capture the current/real time in smartsheets?
Hi there, I want to set up an automation on a sheet where, if a form is submitted/received, within an exact 48-hour time frame I can trigger the mail. From created date column, I can get the time on when the row is created. But I'm not sure about how to accurately track the passage of 48 hours in order to send the email…
-
Need help on a simple IF/AND formula but already spending too much time on it
Looking to show 'Delay' for tasks that have %complete <100% and Finish date < than Today (). Tried multiple variations but some records come right and some just ignore the %complete record. Why? Formula is: =IF(AND([% Complete]@row < "100%", [EMD Finish]@row < TODAY()), "Delay"). This formula is showing "Delay" on tasks…