-
Return list of Unique Entries
Hi, I have list people's names that repeats. Does anyone have a formula for returning those entries which are unique and or/an identifier of unique values (like a 1 that I could use in a helper column if the entry is unique. Thanks, Lisa
-
Count distinct values within cell
a
-
Column IF AND Function Help
Hi all! I cannot seem to get my IF AND statement to work and would sincerely appreciate some guidance! I am attempting to alter/update a cell on one sheet that acts as a matrix for employee training which is based upon information from a reference sheet. Essentially, a row in the reference sheet is populated every time a…
-
Automation Error
Not sure if this is the right place for an automation error or not. I have previously asked about returning a value once (not sure if my link would work for everyone or not). I was able to get it to work with a metrics sheet, a helper column, and a copy rows automation. However, the ID I used for that one, is only valid…
-
Reference the top row everytime when new Form data in inputed
Hello. I am trying to reference the top row's information everytime a new entry/data is inputed into the sheet. For context, when new data is captured in the form and input into the sheet, I want to be able to use a 'Countif' function to count all the '1s' (yeses) in the top row in the Sheet Summary. Here is the formula…
-
Count Down the Remaining Working Days
Good Day Smartsheet Community: I am Trying to Modify my Existing Formula to Count Down the Remaining Days. Right Now it is Static, but I think if I Subtract Today it Should Start Counting Down, but I not sure where to Insert Today in my Formula. =NETWORKDAYS([Q3 Start]@row, [Q3 End]@row) Results: 64 Thanks
-
Notification When a Date Changes
I am trying to work with formulas and notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sent the reminder. In the picture above, somebody will manually enter the Due Diligence Date. The Site Development and Hard…
-
Identify and print 3 most repeated itesm + List of values just once
I'm looking to do this two things: 1- find and print the 3 values most repeated 2- print list of values but just once (if any value is repeated just print once) I have a form that collects tickets of problems in a given apartment. Each problem is a new ticket. So if there is an apartment with 3 problems i would have 3…
-
Identify mismatched status (cells)
Tough one to explain. I have three colulmns that I use a role-based status. Col A (Status for Role 1) - Ingest, In Progress, Complete Col B (Status for Role 2) - Ingest, In Progress, Complete Col C (Status for Role 3) - Ingest, In Progress, Complete When a person with Role 1 changes the Assigned person to Role 2, an…
-
=SUMIF for calculating budget on multiple rows.
Hi! I have a sheet that breaks down different accounts. Some line items within an account will have a cost associated with it. I want to be able to calculate the cost of those line items per account. If I do a simple =SUM formula, it gets confused as things are added, changed, filtered etc. I tried to write a =SUMIF and it…