-
Indexx Match Help
Hi, I am having trouble to make the Indexx Match work. Can anyone spend a few minutes with me to help?? penny.krug@pattersonvet.com Thank you Penny
-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
-
Formula Help Please
I am trying to get a proper formula to add the last total found to a number @row when name matches. I've attempted to use the AI feature but it never works. Please Help!
-
Help with a cross sheet formula: counting unique values when certain parameters are met
Hi there - I'm in need of a little help with a formula for a metrics sheet I'm creating. Metrics sheet looks like this: And I'd like the Units cell to display the a count of how many times a ID Number shows up in another sheet for the month and the year. In this case, the result for Jan 2025 would be 7 (since EQN187742 is…
-
Index/Collect?
I am looking for a formula that will take the "Date Manufacturing" entry for a specific lot number from Sheet 1 (my source sheet, see attachment) and have it automatically populate into a corresponding cell onto a secondary sheet (attachment 2) into the row "Date of Manufacturing" for that specific lot number. I have the…
-
Sheet Summary changes overwritten by other users - can this be prevented?
I have a sheet that has sheet summary values I occasionally need to update the formulas for as factors change however I've found that when other users are updating the sheet (it's a testing sheet) the changes I make to sheet summary formulas are overwritten as those users update their test statuses. Aside from making the…
-
Simple Star Rankings
Here's a single formula to show star rankings (including half stars) for anyone who's interested: =IF(ISBLANK(Rank@row), "", IF(Rank@row = 0, "☆☆☆☆☆", IF(Rank@row = 0.5, "⯪☆☆☆☆", IF(Rank@row = 1, "★☆☆☆☆", IF(Rank@row = 1.5, "★⯪☆☆☆", IF(Rank@row = 2, "★★☆☆☆", IF(Rank@row = 2.5, "★★⯪☆☆", IF(Rank@row = 3, "★★★☆☆", IF(Rank@row…
-
Create a formula to return a check mark
Hello, I am looking for a formula that will return a check mark. Here is what I am using however it comes back #UNPARSEABLE =IF([Personnel Cost Metrics - Overtime]@row "<=3%", 1, 0) Appreciate the assistance.
-
Unable to Calculate Event End Time from Start Date and Duration
I’m trying to confirm if it’s possible to calculate an Event End Time based on our current fields. We have a report that we pull into Smartsheet On Smartsheet: Request Start Time (Duration) Duration (duration field in minutes) Event End Time: (Duration) Formula's that I tried: =[Event Start Time]@row + ([Duration]@row /…
-
Parent/child rows in a report even if not assigned to parent row
I need to build out a report that pulls the below information: Report needs to show the parent and child rows -Parent is not assigned but child is assigned -Parent is assigned and child is assigned I am open to helper columns but everything I have tired is not working. Formulas: -Parent Helper: =COUNT(ANCESTORS())…