-
Behind/Ahead of Schedule by "x" days
Hi All, I'd like to add a column that reflects how many days my project plan is ahead/behind schedule. I asked this question last year, but couldn't find it anywhere. I have a Planned Finish and a Finish Date. I'd like the row to display the following for each: If no variance, display "On Time" If late, display " X days…
-
Calculate Average if another Range meets criteria
Hello, Any suggestions on the best way to calculate the average days if the item type is equal to quarterly? I have a drop-down menu that categorizes the activities based on frequency, and another column that calculates the days past based on end and start dates. How could I find the average if the Item type is Quarterly?
-
Multiple conditions in a formula
Help please. I have no idea how to combine formulas. I just want to round up this 6.83 to 7. What am I doing wrong? I don't want to use the "move over 2 decimal places" in the menu bar above because I need to take the rounded number and times it by a price per hour to get the Cost in another area of my sheet.
-
Nested IF in Checkbox Column when Referencing Another Sheet
Have an issue I cannot seem to resolve to automate a checkbox. I have a "Content" sheet that is data coming from a source outside Smartsheet. Relevant columns look like this: I have a separate sheet (we'll call it "Product Family") that analyzes the data on the Content sheet. Relevant columns look like this: I want to…
-
Nested IF Formula - Project Health
Hello! I'm struggling to complete this formula without receiving errors. I am currently attempting to create formula in a project tracking sheet to return colored symbols (R,G,Y,G) into a "Project Health" Column. Below is the formula that I have so far. It is working up to this point, but when I try to add on IF statements…
-
AVERAGEIF formula but only for specific subset of data
I am trying to determine average from a referenced table with 2 different filters (i.e. Column A = YES AND Column B - X-Small). I can figure out how to AVERAGEIF to filter based on one column but not 2. Almost like i need AVERAGEIFS like COUNTIFS. Any insight would help. I tried testing AVERAGEIF within an IF Statement but…
-
Countifs and formula
Trying to combine the countifs formula with an basically an AND formula. It looked like I should be able to just use a comma to separate but must be missing something because I am receiving an incorrect argument error. =COUNTIFS({Somryst GTM - Project Plan Range 1}, "Complete", {Somryst GTM - Project Plan Range 2}, "Enable…
-
Snipping and pasting into a form field
Any way to use Windows snipping tool and paste into a form without saving a file?
-
Current month checkbox formula
Hi, Can anyone suggest me with a formula that will calculate the current month and check the box as soon as the first day of the month is reached? Layout of my sheet attached below.
-
Flag if DATE A > DATE B
I'm working on a formula for a project tracker in my organization. The request is to flag a row if "Received Date" is greater than "Actual Date" for 3 separate dates - PO Received, Start Date, and End Date. I currently have a formula that works only if all dates are filled out: =IF(OR([PO Received Date]@row > [PO Needed by…