-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
-
COLLECT Formula for Contacts
Hi there! I am trying to set up alerts for a smartsheet document to notify any contact that does not have a specific row updated. I have two columns that I'm currently referencing in the sheet, and I'm hoping that I can have a cell return any and all contacts in a column selection that does not have that box check. The…
-
Flagging duplicates from 2 separate columns
Greetings - I'm having an issue trying to flag duplicates from 2 separate columns in the same sheet. I have been able to flag duplicates in a single stand-alone column but trying to using the same formula with the "COUNTIFS" function is leaving the flagged cell blank (as seen in row 2 of the screenshot attached). Here is…
-
Vlookup Limitation?
Hi I would like to understand about this limitation in vlookup: * Each sheet can include no more than 100 distinct cross-sheet references. * There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.…
-
Multi Select Look up
I'm trying to see if anyone has any ideas of a formula that can been written for the following example. I'm trying to get the contact(mail) in sheet 2 to populate sheet 1(Approval Seq 1 Contact) column. There is 2 criteria (Division and Seq.1) on sheet 1 need to match (Division, Sequence #) on sheet 2 to return the contact…
-
Lookup Table Question
I'm trying to figure out a way to apply my vlookup or index/match combo as a dynamic formula across my sheet. I have a set cell that I can use as the beginning of my array of cells to reference but I want the formula to update the final cell based upon the row I'm at minus 1. There may be a much better way of handling this…
-
Formula for percent match to a multi select column
Hi, I'm working matching mentors and mentees. We would like to match them based on attributes they both selected in a multi select column. As in, choose your top three competencies. Now I would like to make a formula to determine the percent match of a mentee to a mentor's selection. That is Mentee 1 selected A, B, and C.…
-
Count of All Items, where Start Date is less than Today
Hi, I am trying to get a count of all Task Named: "To Do", where "Start Date" is less than Today's date. I am using: COUNTIFS(Task Name, "To Do", StartDate, "StartDate < Today()"), for this, I keep getting '0', but I see there are at least 4 tasks meeting this criteria. Any help if very much appreciated. Thank you, Deepthi
-
#INVALID DATA TYPE when using COUNTIF Formula
Hey Community - I am having an issue trying to use the COUNTIF formula. In this use case, I basically have a formula in the first column to show if start and end dates match with other columns in the sheet. All I want to do is count the number of "Yes" cells, but when I try to use the COUNTIF formula, I get an #INVALID…
-
Countifs function to count ratings by location within the past 7 days
I am trying to create a countifs function to count 5-star ratings by restaurant location published within the past 7 days. The published column contains dates. So far, I have this equation: =COUNTIFS(Rating:Rating, =5, Location:Location, "Bayshore", Published:Published,AND(@cell <= TODAY(), @cell > TODAY(-7)) I am getting…
