-
Copy Row Automation - Eliminating Duplicates OR keeping latest Row entry/update
Hello fellow Smartsheeters, I am trying to capture entries from a project level RAID log and pushing them (based on specific criteria) to an Enterprise level RAID log. Specifically, any Risks or Issues that are created and updated need to be pushed to another sheet. I am familiar and frequently use the Copy Row Automation…
-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…
-
Countifs counting this not in criteria
I am using [Method helper] to tell me when we have more than one online training on a date where Notes= PD =COUNTIFS(Notes:Notes, "PD", [Date 1]:[Date 1], [Date 1]@row, Platform:Platform, Platform@row, Platform:Platform, "online") > 1 I have tried to specifically say, do not count anything with CDA in it, in a variety of…
-
Do leading zeroes affect "duplicate flag" formulas?
I have a sheet with a column of the 'Text/Number' type called "ID Number." My intent is to have another column of the 'Checkbox' type (called "Flag Duplicate") to show at a glance that an "ID Number" has been duplicated (the data in the "ID Number" row should be unique in each cell within the column). I used a column…
-
Task completion (%)
Hello everyone, is there a way to set the % complete based on the task status? I have a table [state ; % complete] I tried with "VLOOKUP" function but isn't possible to insert formulas in the field. Help me please! Thanks
-
Automatic formula
Hello everyone, In some fields in my sheets I have formulas. Is there a way to automatically report these formulas when I add new rows? Thanks
-
COUNTIFS and DATE RANGE
Hello Everyone! I followed a lot of the tips and suggestions that were already on the threads and for some reason I am unable to get the formula to do what I want it to do! I am trying to figure out how many of our initiatives are in a certain stage during a certain date range. The formula that I am using is…
-
What am I doing wrong when using Workday formula?
I am using this formula: =WORKDAY($[Due Date]$1, [Days from Close Day]101, Holidays:Holidays) It is returning Invalid Data Type Error. I think the issue is Holidays. It is working on some rows. I want to add it to new rows and I am getting this error. What am I doing wrong?
-
Can you create a COUNTIF formula with 3 columns?
In a separate metrics sheet, I am trying to count the number of pregnancy studies qualified in the month of October. I want to formula to count the row if the column contains: Type of Study contains "Pregnancy" Phase = "Qualified" Month Name Identifier (Helper Column) = 10
-
Index Match Error
Are you able to help me with a formula problem? I am using a combination of MID and Right functions to pull a number from a text string.... Manager Name = Karri (800014723) Manager ID =MID(RIGHT([Manager Name]@row, 11), 2, 9) Manager ID = 800014723 -------------------------------- Now I am trying to use the Manager ID cell…