We are making a database. We made a sheet for this (AllJobs3) and are attempting to have this sheet pull the Primary Column from a master sheet (All41). We only want the primary column as the database…
Hi SS Community, I have the following nested IF column formula . The formula works properly through the "Red" part, but once I attempt to type DECLINED in the "Revised Final Date" column, the formula …
I have a Symbol column that I'd like to auto-change to Green, Yellow, or Red depending on the date values in my Start, Finish, and Project Status columns. For instance: If Start is in the past and Fin…
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({Program Intake Form …
I'm trying to create an automation that will send an alert when a certain value changes by more than 7. I don't just want an alert for any change, it has to be if the value changes by more than 7. Bec…
I have a formula that says IF(Date@row<TODAY(-14),1,0), to add a checkmark, but how do I add a formula that says once a next recurring date has been added to remove this checkmark.
Hi All, I'm currently having an odd issue with a simple notification automation. Currently we have a notification that is sent to me when any row is changed. Starting today, when items are updated, I …
Any update on this from Smartsheet or a roadmap to do the same? ----- Like many of you I have data (lets call them projects). They come in as an idea on a form, users supply some data, it is verified,…
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of …