-
Import of Excel File
@Paul Newcome Hi Paul hope you don't mind me tagging you into this. the attached file with the tab called "live recording" is the file i am trying to import into Smartsheet's. the issues I am having ( a big issue ) once I import this file into timesheets all my formulas are #UNPARSEABLE. I am really struggling to…
-
Use a reference calendar sheet as a look up table to return values to a resource planning sheet
Hello, I have a resource planning sheet (Controls Resource Planning) that lists task for individuals along with other pertinent information. I have a Start Date and End Date column. I also have Period Start and Period Finish columns. Our company fiscal calendar consists of thirteen, four-week periods. Since I don't have…
-
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…