-
Using CountIfs with several criteria including names, status, and date range
I've created a sheet to build metrics from a very large source sheet. I'm trying to count based on the following: the column {Module 3 - Section Owner} matches a cell in this metric sheet in the "Primary Column" a Date in the {End Date} that is between Today() and the next 7 days. I created three cells that determine what…
-
Formula is not working
Hi - I cannot figure out why this formula won't work - =IF(AND(TODAY(10) >= [End Date]@row, IF([% Complete]@row, <0.75, "yellow"))) Thanks for your help!
-
Date Fromat
Hi, I was wondering how I would change the date format to USA to UK. thanks in advance.
-
Join/Collect/FIND --> Sorting & Concatenation query
Hi All - firstly thank you for all the prior forum articles around JOIN/Collect and multi-select cells requiring HAS/FIND usage, it gave me a terrific starting point to now ask my question around. I have a list of employees in a sheet and I manually track competencies that they can perform technical interviews for. I have…
-
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…