-
Collecting Dates in a Reoccurring Approval
I have a sheet that needs to be reviewed and approved by multiple individuals on a regular reoccurring basis. I have already set up the workflow for this to happen but I will need to keep a list of the dates they were previously approved. Is there a way to use a formula like Join/Collect to do this? When I try it will just…
-
I want to average my column but exclude the zeros from my average
I Am trying to put an average on a column but i want it to exclude the zeros. Further down my list towards the bottom i have zero's. Is there an AVGIF function that will allow me to only include it in my avg if there is a value more than zero? =AVG([Total Truck Invoice Value (Scott)]4:[Total Truck Invoice Value (Scott)]88)
-
Function for looking up data in a range and display "yes" or "no"
I'm trying to pull some data and can't figure out which formula to use. Here's what I need: I have a unique ID in my master database. In this same database, I also have a Budget 1, Budget 2, Budget 3 (the budgets are each in a separate column) for each unique ID - see example screenshot (first 4 columns). I am now pulling…
-
COUNTIFS on checkbox columns with multiple criteria
Is there a way to have a countifs formula on multiple columns? I want to count the cells where PM=Alex and there's a checkbox in the last 4 columns. =COUNTIFS(PM:PM, "Alex", [Agenda 6/7/21]:[Agenda 6/7/21], 1, [Min 6/7/21]:[Min 6/7/21], 1, [Scorecard 6/7/21]:[Scorecard 6/7/21], 1, [Updates 6/7/21]:[Updates 6/7/21], 1)
-
Attachments within the proofing window not downloading
Hi Everyone, My team members are having issues with proofing tool. Within the proofing window, if they try downloading any attachments, they are receiving an error, as attached. When they click on the proof for any assets, the proofing window opens up with the very first version, and not the latest version. The team has to…
-
Countif, Collect, index
I'm trying to count all installations for a site from the master grid sheet to a new grid sheet. The formula I created only brings back two records for each site. =COUNT(INDEX(COLLECT({**Master Grid "installed" column** - Store Install Schedule Range 7}, { **Master Grid "Store#" column** - Store Install Schedule Range 5},…
-
Making an averageif statement that uses multiple criteria like countifs does
Where I have a "Trainee" column, a Rubric Week" column, and a "Score" column that sums the scores of multiple criteria, I am trying to get a running average column for multiple weeks. To say it another way, I have two criteria that I need to meet. I need to average the scores where the "Rubric Week" is a certain week and…
-
Form required fields - preventing form submission?
Hello! I'm wondering if anyone knows of a way to prevent a form from being submitted with empty required fields. Let me know what you know! I'm hoping there is a way to do this. Otherwise, this doesn't feel like they are truly required. Just strongly suggested. :) Thank you so much in advance for any guidance or knowledge…
-
RYG Auto Change Formula
I reached out last week but never received a follow-up response. If anyone can assist me, I would appreciate it! I want the RYG to change automatically. I simply want to change the status of a RYG-ball by comparing two timestamps. ( extracted the time from the Creadted Timestamp). I really want to use some minutes in the…
-
Formula to search another smartsheet for a specific ISBN number
Trying to create a formula that will search an entire smartsheet for a specific ISBN that could be in one of 5 columns. Once located, I then want to create formulas that will provide additional information about that ISBN number in rows that follows that are also in different columns on the sheet. And then want to insert…