-
Working Backwards with Predecessors
I usually work backwards from a due date to determine when I need to start work, so I use the column number and then SF. Typically when I do this the finish date of the task above is the day prior, but now it’s showing me the same day. Also, when I have the duration as 1 day, it is actually showing 2 days. …
-
COUNTIFS with multiple criteria
Hello, I'm having issues with smarthsheet recognizing my columns names. Any thoughts? When I write the Status:Status piece, it does make them active to that column, but as soon as I get to the Submission Date:Submission date portion, it removes the coloring/linking. I've also tried Submission Date:Submission Date with &…
-
Summary Sheet Formulas
I have a column named complete, and I want to track how many items are checked Yes. I'm currently trying to use =COUNTIF( But I cannot figure out the range/criterion values I need to use.
-
How do I return cell values in a specific column based on other sheet and matching reference number.
I have a group of products all with material numbers in a database sheet. I have another sheet that I use as a database change request for for these products. When a user enters the material number on the change request sheet I want other associated values to auto-populate based on the database. Other software tools this…
-
Conditional Formatting Referencing a Cell
Hi, I feel that this is something there isn't functionality for, but I wanted to check and see if I may just be missing something. Right now, I have a list of a numbers in a column and then have it calculating the average, upper limit (the average + standard deviation), and lower limit (the average - standard deviation).…
-
Avg/Collect formula to enter zero
Hello, I have this formula which works as I'd like but what I'm missing is if the answer is zero I want the formula to give me 0 as a response, instead I'm getting #Divide by zero. Any suggestions of what I'm missing? =AVG(COLLECT({days complete}, {Sourcing Owner}, [Contract Manager]@row, {Completed Requests by Month Range…
-
Using References to pull info across sheets
I'm new to Smartsheet, so I expect this to be an easy question. I'm using References to pull info across sheets and I need a cell count from the Category Column with an input of "Category 1" only if the Status Column in that row has an input of "Not Started". Here's a copy of my unsuccessful attempt. =COUNTIFS({Project…
-
Formula Help Needed - Return "50" if date is within a range AND another field is not blank
Hello! I've been working on this formula for hours now and could use some help. I have a column called "Program Date" and a column called "TR". If Program Date is between 12/1/24 and 4/30/25 AND TR is not blank - then I need it to return the value "50" in my "Cost" column. This is where I am at so far: =IF(AND([Program…
-
Updating threat level based on percent complete
Hi, Could someone help guide me with what is wrong with my formula? What I am looking for the formula to output: If the Percent complete is less than 30% within 30 days of the Current milestone date, Threat level is a yellow symbol. If the Percent complete does not equal 30%, today is after Current milestone date, the…
-
Add a checkbox to an email for follow up
Is there a way to add a check a box in an email allowing the reader to advise they are ready to proceed to the next step. This will then trigger an alert on the smartsheet to the admin who will then follow up?