-
If Statement Plus Index(Match()
Hello Again Smartsheet Community, Hoping to get some help with this one. The project I am working on is essentially a group of people will submit a request, based on the submitter they will be assigned to Group 1, 2 or 3. Depending on the group there will be one of several people available to process their request. The…
-
Another question about nested IF statements!
Dear Community, I'd like to combine the two below IF statements, so that if the due date is in the past it will state "Overdue" in the Status column, I can't seem to get it to work :( any suggestions? =IF([% Complete]98 = 1, "Complete", IF([% Complete]98 = 0, "Not Started", "In Progress")) =IF([End Date]@row < TODAY(),…
-
Using If Formula to Populate Status of Parent Row
I am looking for help writing a formula to populate a parent row of a Single Select Dropdown column. The Parent row should reflect the Status of the Child rows - for instance, if any of the Child row statuses are set to Not Started, In Progress, Follow Up Required or On Hold, I want the Parent status to be In Progress. If…
-
Link in assignment with a lookup that is between two dates
We have scheduled out assignments of who has priority for some planes our company uses. This is assigned at the beginning of each week (Monday to Sunday). I want to link in the assignments from our scheduling smartsheet into our tracking sheet that we use for when a plane is in use. This will be used for our tracking in…
-
Average Formula
If I am wanting to find the average of wage rates that are referenced on another sheet, how would I create that formula? I have tried several different things and nothing appears to be working.
-
My Count If formula doesn't work with a < in the field i need to count
I want to count the number of rows which have the <50sqm in the Implementation stage column, i don't get an error with the below formula but this also doesn't give me the correct number, it just returns a 0. =COUNTIFS([IMPLEMENTATION STAGE]:[IMPLEMENTATION STAGE], "<50sqm", [BUILD START DATE]:[BUILD START DATE],…
-
Sum of multi select dropdown items with assigned values
I have a column (Design Software) formatted as Dropdown (multi select). The dropdown values are names of software products. I want to give a value to each software reflecting the respective cost (e.g., Adobe Substance = 3000, Browzwear vStitcher = 19000, etc.). I added the formula below in another column (Software Cost) to…
-
is it possible to list in the sheet the date of updating the sheet automatically?
is it possible to list in the sheet the date of updating the sheet automatically, is there any formula for it?
-
Column Formula with VLOOKUP using External Reference
I love the new column formula functionality! I'm converting to it whenever possible. I am trying to create a column formula that includes a VLOOKUP that uses an external reference for the data set. =VLOOKUP($ROWID@row, {~ Master List Range 1}, 2, false) I am getting an error message, and I think it's because of the…
-
How can use the Countifs function with the Today function in the formula?
Hello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <=…