-
Automated date due to change in dropdown list
Hi folks! We're trying to set up a sheet where we are able to automated fill out different date columns due to a change within a dropdown column. If entry of the status dropdown is changed to pending, the current date should be displayed in the Date Pending column and - important - being locked for any changes. So that if…
-
Collect and display nearest dates
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type…
-
Minimum of a certain range
Hello, I'm trying to use a formula to find the oldest date for a certain range of rows. Is there a similar MIN function as there is to SUMIF or COUNTIF? Or some similar work around? This is my attempt, but it does not work: =MIN(IF({PM Sheet Region} = "TQM", {Column of Dates Here}))
-
Multiple Sheets & Formula Updates
I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when…
-
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],…