-
Compare Date in [Start Date] to a value in a text/number column
I need to compare the date value that is in the Start Date or End Date to a date value that is in a text/number column. When I compare the two, I get "#Invalid Operation." If I change both columns to Date columns, it works, however that does not work well with my spreadsheet. Are there any tricks to doing this? Thanks
-
##Help ME please "i can t continue to work" SumIF##
I post a problem 2 days ago some response but still doesn t work, new to smartsheet but my work is blocke now problem Hello @Craig and other Helpers i experiment the same issue than other sorry for my english but i m french i copy your formula below and try to adapt with "laserjet" type i want to make a sum if a name…
-
Cash Flow Projection in Projects Sheets
Hi, I am using =IF(AND( ... )) to project in which month a disbursement will be made in a project planning sheet. Does anyone use an easier faster way of scheduling disbursements and depreciation? Regards
-
Quarters in fiscal years formula
Hey all, I'm trying to write a formula that will return the quarter and fiscal year (FY) of a given date. Our fiscal year is October - September. So for the first quarter, the FY doesn't match the calendar year (CY). So far I've been able to execute this for one CY, but if I try and add a second CY, I get back a blank…
-
Nested IF Statements
Brand new to SmartSheet. Looking for best method for nested IF/THEN statements to provide status. Or alternate methods. Example... IF column N has any value, THEN column B shows Status 1, IF column O has any value, THEN column B shows Status 2, etc. My nested IF/THEN statement from Excel didn't import.
-
Indenting not working right
See screenshot. When I indent my headers, the expand/minimize button is all the way to the right (circled in red). I would like it to be in the cell with the header label. I cannot figure out why it keeps putting it all the way at the end. Second- When I try to do additional indenting below that point, it doesn't seem to…
-
Future Date Calculation
Hello, I am trying to find a formula that will calculate out 90 days from a given date AND give the result as the last day of the month. The given date is Completion Date Estimate i.e. 10/31/2017 of a project and I would like a cost cut off date that is 90 days later on the last day of the month i.e. 01/31/2018. One…
-
Duration in a summary task show "hours" instead of "days"
I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks? Thank you, - Blake Chesley
-
Round to nearest 0.5
Hello, We are building a time management sheet based upon a simple Smartsheet feeding information from a Form. After we've received the information we want to round the calculated results to the nearest 0.5 (see screen capture) The data we receive are collected and calculated in plain text/number columns. The Round formula…
-
IF Formula Help
I'm terrible with formulas! What would my formula look like to do the following: I have a listing of open action items, each with an attached target due date. I need the RYG overall project status balls to update automatically. Green if no action items are past due, according to the target date column. Yellow if one action…