-
Return true of Date equals a date within a range of specified dates
helper column =IF([Deploy Date]@row = [Deploy Date]29, 1, 0) Works fine. If the date in the row equals the date in row 29 - returns 1 However i'd like it to search within a range of dates and i'm clearly missing something. =IF([Deploy Date]@row = [Deploy Date]28:[Deploy Date]39, 1, 0)) I'd like if the deploy date @ row…
-
Modify criteria for Schedule Health
Hello, I am trying to modify the criteria for the Schedule Health using the Project Management Office Template (https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8) Currently it calculates the health based off of the actual and target start/end dates, however, I'd like for it to also factor in the %…
-
How to reference to the last row of a colum?
Hello, I have sheet to where I add rows with a smartsheet form so the number of rows increases. At the top of the sheet I have a metrics section where I want to sum (with a SumIF function) the rows starting from row 10 to the last row. How can I do that? Thanks, Risto
-
EOMONTH Formula
Hey everyone, I am trying to add a formula to my pay run sheet. I have tried =IFERROR(DATE(YEAR([Invoice Date]@row), MONTH([Invoice Date]@row) + 1, 1), DATE(YEAR([Invoice Date]@row, 12, 31))) + 30 which works, however, I need the month-end date and not +30 days as not every month has 30 days. I need my payment date to read…
-
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…