-
If Formula
I have a sheet that has a score (0-5) for an inspection performed. If the score is <=3, the re-inspection date needs to be 2 weeks from the original date of inspection. If the score is <= 4, re-inspect date is 30 days. If the score is <= 5, re-inspect date is 120 days. I an attempting to use multiple if statements but not…
-
Health status in a project plan
Hi, I am wondering if anybody can help me with setting up a formula that flags Red, Yellow, Green, Grey based on Status and Due Date. If the status is complete, grey. If the status is not complete and the due date is more than 5 working dates days in the past , then yellow. If the status is not complete and the due date is…
-
Health status in a project plan
Hi, I am wondering if anybody can help me with setting up a formula that flags Red, Yellow, Green based on Status and Due Date. If the status is not complete and the due date is in the past more than 5 working dates days, then yellow. If the status is not complete and the due date is in the past more than 10 working days,…
-
Returning a cell content if a name exists in a column
Hi all...another newbie question. I'm trying to create a report that shows, by person, the project that they own and the projects that they are a "stakeholder" in. I have a report titled "Projects" that has project title column "Project Name", a column where one name exists "owner", and another with multiple names…
-
Formula Needed
Good day everyone. I am writing a sheet for our proposals to our customers. I would like to have the tax column fill in the appropriate tax for each line item. I have a second sheet with the tax rate for each county in our state. What I need is a formula that will calculate the tax for the appropriate city that is entered.…
-
Reference Sheets
Hello - I have a master sheet with a property list and billing information associated with each property. I have another sheet responsible for onboarding new employees and would like to set up a formula that populates information from the master sheet depending on the property name entered in a cell within the onboarding…
-
Combining SUMIFS + Specific Date Range + Specific Criteria
Hello Smartsheet Community! Hope you are all doing well! I am stumped on how to achieve the results I'm looking for and am looking for some assistance. We are pulling data from one sheet to another, in this scenario. Step 1, which I was able to figure out is to sum the number of "Potato Orders" in a certain date range:…
-
Countif formula for multiple items in parent row
Here is my table: In the Gender ID column I'd like to see a count of M and F in both the 1st and 2nd hierarchy rows. For example, in first row, K, it should end with M-2 and F-0 and the same in the 2nd row, Frizzle. For the row, 4, it should return M-3 and F-3, but under row, Dumbledore showing M-2, F-1 and Yoda M-1, F-2.…
-
How to create a column formula that adjusts time depending on length of previous row
We are scheduling surgeries and need to adjust start times according to the previous procedure length. I am currently using a Time column and a Length column and a VLOOKUP formula pulling times from another sheet in the background... =IF(lvl@row = "0", "", IF(lvl1 = 0, "09:00", IF(Length1 = "50", VLOOKUP(Time1, {Time…
-
Is it possible to reference the value in a cell at a fixed offset?
Wondering why there seems to be no difference between absolute and relative in smartsheet. I would like to pull the date from the cell three up and two to the right of my target cell, no matter where the parent row is dragged to. Whether or not I add the traditional $ before the row number or not, the reference always…