-
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 =…
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…
-
OR function referencing other sheets with Index - returning INVALID COLUMN VALUE
This is driving me nuts. Sheet1: {Sheet1_CC} = Course Code (Text/Number Column) {Sheet2_MRC} = Modify Replace Code (Text/Number Column) {Sheet1_AT} = A Task Dropdown list with restricted options (NEW, MODIFY, REMOVE) Basically a course code can be in either column and I need to pull relating task into Sheet2 Sheet2:…
-
Formula to copy the information of one cell into a different cell
Is it possible to use a formula to copy the information of one cell ( In this case the cell is under a date type column) to another cell (also a date type column) . For example, if my cell #1 under column "concept start date" is: 06/19/19 then automatically my cell #1 under column "Start" would automatically fill up as…
-
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
-
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 can I change this formula to exclude holidays?
I have set up a project status report to automate expected deadline dates for certain project deadlines. My current formula excludes the weekends, but not holidays. What can I change/add to this formula to do so? =IFERROR(WORKDAY([CD Kickoff (E)]@row, +1), "") Also, if I need to have the dates counted by 4 weeks vs days…
-
Auto Generating a Sequential Document Number Based on Cell Criteria
What formula can I use to auto-generate a sequential number into the Document Number column for each row based on the information placed in Company, Department, and Type? I need the numbers to look like this: PBI-ACT-FRM-0001. "Company-Department-Type-Sequential Number" We have several Department and Type options in a…
-
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…
