-
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…
-
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…
-
Copy and keep cell value based on day of the week.
Hello All, Is there a formula that would take a value from cell "A", copy it to cell "B", and keep that copied value in cell "B" until a set number of days have passed? Backstory: I currently have a dashboard with graphs that illustrates a rolling 7-day, 30-day, 60-day, and 90-day account interactions. I would like to…
-
Formula result from another formula
Hello, I need some help :) I need to calculate the [Taskl Name] and the [Status] from the next "milestone" in progress, and put those values in a header of the sheet. To determine the next "milestone" in status "in progress" i use the following formula, in every "milestone" row, on column: [WF-Multiplier]…
-
Form with formula INDEX/MATCH
Hello! I'm trying to see if this is possible. I'm creating a calibration form, but I'd like a specific task duration to be tied to each item, which then populates the due date. For example: Each piece of equipment has a set duration (ie. 365 days). This would be hidden on the form sheet. Once a user submits the form, I'd…
-
Average formula
Hi, Can you suggest me with a clever way of calculating average for a group of cell references? Please see attached screenshot of my sheet. Anytime the data for a new month is entered into my sheet, I need to manipuate the average 6 months formula so that calculates the average for the latest 6 monthly only. Is there any…