-
Dynamic Cell reference in MAX() formula
I have a Project Management sheet in which I use the auto generated modified date for a clomun named "Last Updated On". I don't need the row specific date, but use the values in a MAX([column]) formula in a data roll-up sheet to determine when the project last saw any activity for management review. Recently, I discovered…
-
Can you write a formula in column 5 to populate column 4?
Is it possible? Can you write a formula in column 5 to populate column 4? I need Column 4 to just rewrite what is in Column 3, BUT the formula will need to be in column 5. And it only needs to it to be written if column 6 has text.
-
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??
