-
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…
-
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…
-
Automated Workflow for Forms and Reports
I created a form to collect data from users (while at the same time protecting my sheet). I need to collect data from users on a monthly bases, and I'd like to be able to send the Form I created at the beginning of every month. I also have a Report that I'd like to send out to managers at the end of each month. I know can…
-
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]…
