-
Subtracting Dates to determine what is less than 90 Days
Maybe I need to use a different formula, but this was successful in returning "Short" for everything, rather than anything under 90 days. We are trying to call out short start projects or those that require less than the average 90 days, so a difference of 90 or over should return nothing. =IF([Anticipated Activation…
-
COUNTIFS & AND + <>
Hello, I appreciate your help in fixing this formula. I want to exclude from counting any blank cell for one column & any cell with "Center" from another column. The one for excluding "Center" is not working. =COUNTIFS(AND([Deliverable(s)]3:[Deliverable(s)]137, <>"", [Responsible Party]3:[Responsible Party]147,…
-
All Dates populate based off one date
Hello, I am trying to create a sheet where I can put in one date in the Target Start Date column then all other dates populate from that date based off the duration it takes to do all the task. Is this possible?
-
Sum by Date Formula - Need Help
=SUMIF({CFL Batch Summaries 2021-Present Flower g}, {CFL Batch Summaries 2021-Present Harvest Date}, YEAR(@cell) = 2021) I am trying to use this formula to sum the total grams if the harvest date was in the year 2021 but am getting "Invalid Operation". =SUMIFS({CFL Batch Summaries 2021-Present Flower g}, {CFL Batch…
-
Formula to trigger red flag based on conditional formatting rules?
Is there a formula that will mark a flag red based on conditional formatting of other columns in a row? For example, I've set up multiple conditional formatting rules within a tracker sheet. I'd like to have a checkbox column with a flag that would turn red if some of those conditions were met using conditional formatting…
-
Invalid Operation when using Today() in nested IF STATEMENT
Here is the formula I am working with: =IF(ISBLANK([Start Date]@row), " ", IF(ISBLANK([Actual Start Date]@row), "Not Started", IF(ISBLANK([Actual End Date]@row), "In Progress", IF([Actual End Date]@row > TODAY(), "In Progress", "Complete")))) When I have dates entered for Start Date, Actual Start Date, and End Date the…
-
How can you use the check-list function to build a master smartsheet?
Hi all, I was wondering if someone could help me out/let me know if this function is possible. I am trying to create a comprehensive template of all activities in a project, with the idea that members could check a box to include that activity in their specific project. Is there a way to automate it such that when you…
-
Checkmark from another value
Hi, What is the formula to have my checkmark checked with my status is changed to a certain value? i.e. when the completed status is selected, I want the checkmark to be checked. thank you.
-
VLOOKUP? INDEX MATCH? invoice amounts from sheet 1 into sheet 2 based on a matching #
Help please! I'm looking for the invoice amounts from one sheet transfer into another sheet based on a matching CAR#. For example: if CAR# FP2020-1 is listed in spreadsheet (B) then I want the invoice amount associated to populate into the $spent column in (A). I'm running into confusion because I can't figure out how to…
-
VLOOKUP on column with letters and numbers results in #NOMATCH
I have a simple VLOOKUP to pull back the related column from a 2 column table. It consists of either letters only (WORD) or numbers only (123) for each entry but entries span both types. When the function is in place I receive a #NOMATCH error for all the letters only entries. I've tried adding a helper column that refers…
