-
Number of duplicates
Hello, I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names? Many thanks, Pltrmgrl
-
Time and Date Calculation
Back to SLA calculations, this calculation worked in the previous wave of Hypercare, but for some reason isn't doing so now. Background: We calculate SLA based on Priority Critical=4, High=8, Medium=24, Low=48. Actual SLA tracks how long a Ticket remains open. I know I am missing something. =IF([Tracking Status]@row =…
-
Divide by Zero Error With AVG(COLLECT(...
Hoping someone can help because I am totally twisted with this one. I don't use AVG(COLLECT very often so I may be missing something simple here… What I'm trying to do is take the average of Column17 where both the year (Column22) and the weekday (Column9) match the year and weekday that I've indicated in Column21. (Yes I…
-
Require all approvals received before setting status to Approved
I have this successfully working column formula in Overall Approval Status: =IF(COUNTIF([Approval - Kashif]@row:[Approval - Adam]@row, "Declined") > 0, "Declined", IF(COUNTIF([Approval - Kashif]@row:[Approval - Adam]@row, "Approved") > 0, "Approved", IF([TEAM A - Approval Requested]@row = 1, "Submitted", ""))) From AI: The…
-
Formula to Check Restricted items in a Multi List Drop Down
I have a field "Failure Summary" in a sheet that has a drop down list that allows multiple selections. I want to write a formula that will check mark those specific items in the drop down list, if a corresponding column@row has "NO" as the value in that field. Is it possible to write a formula to do this?
-
Dynamic Formula to links multiple sheet based on Sheet Name
Dear Team, I have multiple folders (Individual Project) in workspace which has multiple sheets in each project folder. Is there any dynamic way or formula to link the individual sheets data (example Total Budget and Actual Cost) based on the Sheet name (Main Sheet contains a Columns Projects Name which has each Project…
-
SmartSheet Data to Excel Macro OR Any Alternatives?
Hello, I am new to SmartSheet and have been working on a project. Currently, the data I am working with is entered through a form by users and inputted from there into a SmartSheet. The data I am working with is free-text text boxes (so things like comments, etc.) and I was tasked with coming up with a way to sort through…
-
Calculating Time Worked for Employees
I have a start time and end time in my smartsheet but need to calculate hours worked. Has anyone used a formula before to do this? if so can you pass along?
-
Is it Possible to Automatically Update a Dropdown Based on Booking Counts?
Hi there, I need some input on setting up my workflow and I'm unsure if it's possible. I have a scheduling sign-up sheet where people sign up by date, and each date has a limited number of spots. I want the date option in the drop-down to be removed once the count of bookings for that date reaches "0." Screenshot below for…
-
Percentage of check boxes - Need to exclude blank cells
Hello! I am working on a formula to calculate the percentage of boxes checked. This formula is currently working when I set the range to exclude the blank cells. However, I need to allow space for more rows to be added in the course name column in the future. I would like to make this formula to exclude those blank cells…