-
How to Write IF Statement for a Symbol Column
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 Finish is in the future and Project Status is not "Complete" or "In Progress", Symbol changes to Yellow. I really wish…
-
VLOOKUP or INDEX MATCH Referencing Another Sheet
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 Range 1}, MATCH([Project #]#, {Program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {Program Intake Form Range 2}, 5,…
-
Is there a way to create alerts for non-specific changes?
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. Because of the nature of this specific value, it isn't really possible to have a helper column, at least not that I can tell.…
-
Uncheck Box
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.
-
Add "Remove" field in Automations of Attachments
Seperate out the value that feeds into "Changed" when there is a removal of the attachment keep the rest.
-
Automation Notification - Only getting notifications on app?
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 get the notification via the app on my phone but do not get the notification in smartsheet (sidebar bell on web) nor do I…
-
Mid 2023 - Smartsheet Move/Copy row still all or Nothing?
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, and achieves a stage to move on, When it moves on it has accrued much data that does not need to move with it so only SOME…
-
Can Smartsheets talk to each other?
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 an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…
-
Automation emails to ALL contacts in a contact cell?
I feel like i'm missing something because it appears others have been able to do what I cannot. I have a contact column and some of my vendors need the emails to go to multiple people each week. I setup "allow multiple contacts" and entered their email addresses, but the automation is only sending to the first contact in…
-
Merged: New automation to copy cell content to another column (for capturing baselines)
This discussion has been merged.
