-
Cross Sheet referencing
Hello, I have a master sheet, where I am keeping track of the progress of various tasks. The progress is being monitored using checkboxes. The structure of the sheet will be clearer through IMAGE A. Each project has it's own smartsheet and I would like to format the master sheet based on targets met in the individual…
-
WEEKDAY formula is giving me the wrong result
Ok, am I missing something obvious or is the formula not working properly? As shown in the image, the date is 6/2. Which is a Sunday. But when I use the "WEEKDAY" formula to reference the date column it keeps coming back with "2," indicating that it's Monday. What am I doing wrong?
-
#Invalid Operation
Hello, I have this formula: =IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE") I've tried a few things but I keep getting invalid operation, and I'm sure it's something foolish and easy but I can't seem to figure it out. Tahnk you-
-
Count Raised flags under child and grandchildren
Hello everyone, I am trying to wrap my head around this one and I'm sure others have too. I want to count all the Flags that are raised under a grandfather (Administration) : the children and their grandchildren. Currently my solution works, but it's weak. It depends on a fixed range, and as time goes on, new grandchildren…
-
Problem with SUMIFs second critera based upon date
Hello, Smartsheet example here: https://app.smartsheet.com/b/publish?EQBCT=e6247aff028844ff9da1e4d0906860c2 What I am trying to do is the following: =SUMIFS(Name1:Name14, "Happy", average1:average14, Date1:Date14, >TODAY(-31)) / COUNTIFS(Name1:Name14, "Happy", Date1:Date14, >TODAY(-31)) Basically the following critera: *…
-
Sumif Formula
Hi, I'm having problem with my formula below. If I update the column 2 to reference "Amount Invoiced", it automatically change the formula in Column 1 to "AmountInvoiced". I need Column 1 to only reference PO Amount and not Amount Invoiced. See below sample formula that I input on the sheet. Column 1 =SUMIF({FY19 MASTER PO…
-
How to put together two formulas to account for blanks
Hello, I have this formula to add 10 days to a date: =[Date1]@row + 10 Then I have this formula to leave blank if there is no date: =IF(ISBLANK([Date1]@row), "") I need to put them together so if there is a blank the cell stays blank but if not then it needs to add 10 days to the date in [Date1]@row. Thank you!
-
How to tell if Multiple Invoices have all been processed
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Return value if one condition is met
Good Morning, I am trying this formula within my sheet in a brand new column: =IF([Planned Start Date]@row - 21 <= TODAY(), [Estimated Hours Number]@row, "") For this column, if someone put a date that falls between today and three weeks from today, to return the job site hours that is found in the column Estimated Hours…
-
Counting for a Blank Cell
Hello! I have this formula that works great: =DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3))) But if my date in "[Completion Date]3" is blank it throws off my whole formula. What can I add so it stays blank if I have no date in "[Completion Date]3". THANK YOU!
