-
If checkbox is checked, do a popup
Hi! If possible, I'd like to prompt a notice/warning for a user if they check a checkbox, to perform an action. For example, if they check a checkbox on a question I ask, it should prompt them to fill out the "notes" column next. Is this doable? Or any options otherwise?
-
Date range calculation, count month numbers
Hi All Could I please ask for some help with a date formula? I'm working on an online education project. Each module takes around 6+ months to complete, see below the date range that starts on 14 July 2020 and ends on 25 Jan 2021. I need to count how many modules occur in January, how many in February, how many in March,…
-
Average Formulas
Hi all, I need some help with average formulas please. I have a sheet that contains the following relevant columns: Date Received (dd/mm/yyyy) Business Type (Investments, Pensions, Mortgages etc) Amount Invested Initial Fee Initial Fee % (calculated from Amount invested and initial fee) Date Processed (dd/mm/yyyy) Case…
-
Index using Large function
Basically, I want to recall the name of an object based on the number of occurrences that exist. The number of occurrences already exist in an helper column as. I was able to use Index and match to return the first name of object that have that occurrence, the problem I am facing is, sometimes there exists a duplicate…
-
Help needed - AVG(Collect).. - #divine by zero error
Hi, This is Ryan and help needed. I'd like to get an average value either project status with ''in progress'' or ''complete'' whichever data available but with below formula, it shows #divine by zero' error. When I try use only 1 condition either "in progress'" or "complete'', then it returns value. =AVG(COLLECT({OSAT…
-
INDEX calling data that is drop down format?
Hello, I am having difficulty using INDEX. I would like to use it to call a data point into a new sheet, but the data it is calling has been input in a dropdown format. The formula works for data that is text, but gives INVALID VALUE when the data being called is from dropdown. Is there anyway around this? If at all…
-
Sumif amt is equal to specific date
I am trying to total $amt to a specific date. I can get it to sum a whole month however I cant get it to total a specific date. Can anyone help?
-
Lookup contact name from email address
Hi, Users enter data into a sheet via a Form. One of the columns is a "Created By" system column. This provides me with the email address. Is there a function to lookup the name from the contact list based on the email address. I'm aware that I could achieve something similar by have a second sheet with Names and email…
-
Trying to Average Days based on a Text Field Criteria
I am trying to get the average days that a contract took to execute after a specific date, however only for items with the text status of Support, what is the best way to do this in smartsheet? =AVERAGEIF([Status]:[Status], "Support", [Contract Signed]:[Contract Signed], >DATE(2020, 7, 1), [Contract to GL Days]:[Contract…
-
Need help with a function
I have a sheet that has 2 columns Required for (Sprint 1, Sprint 2,.....) Build % Complete (values - 0%, 50%, 100%) I need to know how many Sprint 2 items have 0% Build % Complete. My function is COUNTIFS(<Required for:Required for>,"Sprint 2",<Build % Complete:Build % Complete>,"0%") This function is always returning 0…