-
I am trying to get the highlighted formula to exclude weekend days.
The way the sheet is currently setup, each row is a different job. there are no parent or child lines. I am trying to set a milestone date from one department task to another. However, the formula doesn't seem to recognize or account for when dates fall on a weekend. 1/6/24 and 1/7/24 are both weekend days. How can i write…
-
Summarizing Values In Last 15 Work Days
Hi all! I would like to create a report that has a list of names, as well as the hours logged in the last 15 working days (weekdays). Currently, we have a sheet that has all accomplished tasks inside of it, attached to those tasks is the name of the person assigned to it, as well as the hours they committed to it and the…
-
#INVALID OPERATION for multiplying with zero
I am trying to multiply two cells and I get and error when one is a zero. The "Number of Boxes to Order" column has an IF formula in it. The price column has a link from another sheet. I'm not sure why I'm getting an error when the IF formula spits out a zero value.
-
Health Status
Hello, I am new to using formulas in SmartSheets. I want to have my Health Status reflected "green" when the "employee suspension start" date is within 4 days (for example, employee suspended February 19, 2024 should reflect green through February 23, 2024) then yellow from 5-12 days (previous example February 24 -…
-
Is it possible to include a formula in a hidden field in a form?
The reason for asking is we are creating a smartsheet with form for training candidates to register their names, which will then create a certificate using document generator. In order to get the certificate PDFs to have a unique file name I have added a column called file name with the formula ="COSHH Training Certificate…
-
CountIf formula for status and priority
I am trying to code a count if formula for two columns so I would like to count by status and priority. I have the table created and the values manually entered, but I would like to code this to summarize the sheet values automatically. Does anyone know the formula to use?
-
Report showing particular sheet Parent+Children rows
I want to populate a Report with a particular Parent row (level 6 indent) + it's children. The sheet is a very large schedule running to more than 1000 rows and with 7 levels of indent and counting. This is something I need to do on a regular basis - is there some hack to achieving this?! Thanks, Robert
-
Problems refreshing a VLOOKUP with new data
Hi, A couple of weeks ago I successfully created a VLOOKUP between 2 sheets, and updated it with new data last week. However, today when I tried to do the same refresh, I am consistently getting #NOMATCH whenever I reference the new sheet. I tried deleting all the sheet references, making new references, clearing out all…
-
#UNPARSEABLE Sumifs
My sumif formula keeps coming up unparseable and i can't figure out why. I'm not even getting the highlighted frame for when I identify the column I want to be summed. What am I doing wrong? =SUMIFS([# of Car Seats]:[# of Car Seats], [Date Distributed]:[Date Distributed], AND(@cell >= DATE(2023, 10, 1), AND(@cell <=…
-
How do I create an email confirmation?
How do I set up a "red flag" if the email that is entered second does not match the first entry?