-
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…
-
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…