I'm trying to find a solution for populating a start and estimated completion date for two tasks simultaneously. For example, I use headings for Start Date, Est. Completion, and Completed. I have a ta…
I'm trying to make the parent row say the qty of children AND the % in the "Complete" column that will auto adjust once checkboxes are clicked. Note, each parent row will have different quantities of …
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]) formul…
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 b…
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…
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 yo…
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}),…
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…
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?
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…
