-
Change Dropdown Option in Cell Depedning on Date
Hi all, I have a column titled "Interview Date" where the date of an interview is inputted. I also have a column titled "Status" with two options - Open and Closed. I am trying to make a formula that will set the status column to "Closed" if the interview date is in the past. I am trying the following but cant get it to…
-
#CIRCULAR REFERENCE with =SUMIF Formula
For each month, I am trying to sum up data depending on the type of project it is. For example, "If the 'Project Type' is 'Strategic', this is the total hours for the month of February," "If the 'Project Type' is 'Operational', this is the total house for the month of February." These the formulas I tried using:…
-
Summarizing a column based on another multi select column
Hello - I have a column named "Monthly Hours" that lists hours (integers). I have another column called "Site of request" that lists the site(s). That column is multi-select. I would like to summarize hours spent per site. So, if the "Monthly Hours" column has a 10, and the "Site of request" lists "Site A" and "Site B",…
-
formula to create a repeated number sequence in a formula column
I have a 400 claims (and growing) that need to be assigned to three claims examiners. I would like to evenly distribute the work, so I would like to create a column formula in a helper column that simply repeats 1-2-3, like this: row 1 - 1 row 2 - 2 row 3 - 3 row 4 - 1 row 5 - 2 row 6 - 3 In Excel this is simple, but I'm…
-
Match Numbers from one sheet to another
Hi I'm trying to make a inventory with a reference from a another smartsheet sheet, but since im kinda new into Smartsheet I dont know which formula I need to use. Its a hole Row from one sheet and then tell if it exist or not in the one that im working on.
-
How to create a deadline column for it to be three days before the deadline that was put in the form
I am trying to create a workflow (I think) that when someone completes my form and enters their requested deadline in the form, there will be an automatic column that will show three days before that deadline requested. I want that date to automatically show three days before the requested deadline so that we can get…
-
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…