-
Help with COUNTIFS and NOT CONTAINS formula
Hello, I have looked for this all over the smartsheet community, and while there are some responses, I still cannot get this formula to work. I need assistance with the following: I am looking for a count if of all "low" priority from one column on a referenced sheet that are not "complete" in a different column on that…
-
Automating the Documentation of Historical Values without Workflows
Problem: How to automatically document historical values without using the automation workflow. I have a two-line graph of which one line (let's color it black) represents desired results within a date range. This date range ends in the future. The second line (let's color it red) represents actual results within the same…
-
Is a cell value driven cross sheet formula possible?
Our projects have a subfolder with any number of sheets that all have the same data layout. We need a summary sheet that fetches a status value from each child sheet, but i can't figure out how to do it in a way that wouldn't take 90 hours of tedious work - that would need to be repeated forever and ever In excel i'd use…
-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
-
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…