-
Count matching values in date range.
Hello Gang, I've been losing my sleep over this formula so I thought of asking here. I need to determine whether a certain value is found in another sheet and if the date of that value if found within the date range of the matching value in the second sheet. Example Sheet 1 includes the following columns: DEP,ARR, DATE…
-
Is there an issue with using an IF statement across multiple sheets?
Hello, I am having trouble using an IF statement across multiple sheets. Basically, IF a row has a specific word, it should pull the column I need. Or was there never a link like this before? Thank you!
-
How can I use an IF statement with INDEX/DISTINCT?
Hello, I am trying to pull distinct information from a different sheet if a box is checked. Here is my formula to pull in the distinct information: =IFERROR(INDEX(DISTINCT({Source Sheet Column_Name}), ID@row), "") Now, I have a checkbox column called AX S2 and I just want the information from the rows that are checked in…
-
Index Match Row Number Update
Hello, I have an index match formula but when I drag it down, the row number doesn't get updated and just drags the same formula down. Is there a way to drag this down and have the formula update rows? Formula: =INDEX(COLLECT({OSS Test Range 1}, {OSS Test Range 4}, "New"), 1) I'm referring to the number 1 at the end of the…
-
Flag an item
I am trying to flag a line where the Actual Finish date is blank or the Actual Finish date is past the Estimated Finish date. How would I set that formula up?
-
Formulas from Forms
Hi there - I have created a form with 4 questions that has dropdown (multi select). In the smartsheet itself, I need formulas for the following: If all boxes are checked then show 0 If only 2 of the 4 boxes are checked then show 10 Please help, thank you!!
-
How to List New Options From A Multi-Choice Column As a Value In Another Sheet?
Hey Guys, I've been trying to find a solution but I'm stuck. I have a 'master' sheet that has a multi-choice column for countries of operations for some partners. The choices will increase over time as my partners increase their countries of operations. I am trying to create a formula that will use this column as a…
-
Notifications not working
I created the sheet and set up the automation as below. however, it doenst trigger to send the notification for the current week unless I open the smartsheet. it still send out last time I open the smartsheet How do I make it send out every monday without touching the sheet??
-
SUMIFS with a date requirement included.
I have a Disbursement tracker, showing Request Status, Date Requested, Amount and Project. I have another sheet, Project Plan showing the summation of Disbursements by Project. I am currently using the formula below to summarize all Amounts that are disbursed. I am using my request status column and including everything…
-
Formula for Dates Calculation
Hello, I am trying to find out how I can create formulas for the below. Kickoff Date - Number of rows with a kickoff date by month? IE Count of projects in a column with a kickoff date in Jan, Feb, March etc Average days in IMPL - The average number of days for all projects. IE: kickoff day in my sheet vs current day for…