-
Using COUNTIFS when two different ranges
I need a count of items with program = "VRN - Website" but do not count the ones with status = DONE OR NEW =COUNTIFS({Programs}, "VRN - Website", NOT [{Status}, "Done" OR "New"]) What am I doing incorrect?
-
Formula to Capture Active Projects Assigned to an Individual ONLY
I'm currently having trouble figuring out how to capture the number of status specific projects assigned to an individual. I've attempted the "COUNTIFS" formula many times, but can't seem to configure it so that it counts the number of projects by assignee IF the project status is one of the following: Not Started In…
-
Formula to calculate days between two potential start dates
I have a basic report request form and would like to know if I was 'late' in completing the request, which would be simple - but I have the client provided due date column and an adjusted due date column that I enter (to balance impossible timelines - and i want to keep the original request intact). How can I see if my…
-
COUNTIF formula with 3 criterions
Hey everyone, I am trying to create a formula that counts the cells that are true with two criteria and are flagged red. =SUM(COUNTIFS({All Nexii HSE Incident Reporting Range 2}, "Hazard ID - Behavior", {All Nexii HSE Incident Reporting Range 1}, "Squamish", {All Nexii HSE Incident Reporting Range 3}, "Flag")) The formula…
-
How do I write a formula to return a category based on the item(s) in a cell?
In this example, the first column contains various fruits and vegetables (multi select dropdown). I want to write a formula that returns the category (fruits or vegetables) based on the first item Thanks!
-
Overide a formula with another
I have the following formula that works great because I can add estimated times in until real-time data is available that is referenced to another sheet. Except sometimes I have referenced data that is really off and I want to use the estimated time until I can research the issue or until new data is put in the other…
-
What does the LOCK do in the summary sheet?
I have a formula in the field, I locked it but I can still edit the field.
-
trying to compile "other" comments from a survey
Hi! I am trying to compile survey data into a single page. The same survey will be used over and over and the data will keep adding to the data sheet. I have a few multi-select dropdown columns, which each have an "other" category that then opens up the "other" field in the survey if selected. Often, this is not used. I am…
-
Counting Financials within Past 365 Days (Year to Date)
Hi, I have a Smartsheet that counts financial errors by individual. I want to change this so it only counts figures Year to Date. I'm therefore trying to manipulate my formula to only count within the past 365 Days. To make it more complicated, I'm referencing from a separate sheet. I've tried (TODAY) - 365 but unsure if…
-
How to auto-populate fields in a form based on a drop down menu?
Hi, I am trying to create a form based on a list of where for instance, one account has different line of business only applicable to that account, I would like these to be shown once the account is selected from a drop down menu. I was thinking on a VLOOKUP formula but I don't see how I can use this is the form creator.…