-
Automatically Check a Box upon entering a date and time
Hello, In my Smartsheet sheet, I'd like to set up a system to check off meetings automatically. I'd like to enter a date (ex: 04/15/23) in a column and the time span in another column (ex: 12:30 - 2:30 PM). It would then automatically check a box in next column if the start time have already passed. Any advice would be…
-
Form Options - Automation
Good morning, I'm trying to create a form in for entering and/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but also times where both apply. Essentially, our wish is that the contractor would complete the form and if they check a box…
-
Employee Main List Formula Modification
I am currently using the Return to Workplace template set. I want to modify the formula being used on the Employee Main List Sheet to only collect trainings attended if the column next to it says a specific project phase (Dropdown). I am dividing the trainings by phases but I don't want the Trainings Attended to account…
-
Alert Someone Automation Template
Hi all, I am trying to set up an email automation to email myself the contents of a contacts field for all the rows on my Smartsheet. They way I have it set up now, it is only sending me the first row and that's it. Am I missing something? Thanks in advance, Frank
-
Looking for solution to add Outlook calendar invite information to Smartsheet
We want to create a Smartsheet that is automatically populated with Subject, Location, Date, Time, Duration when we invite an alias to a meeting. Is anyone aware of a way to do this? We would do this for all of our project/program meetings to help us provide corporate visibility to the meetings and attempt to avoid…
-
Alert for Automation being set as disabled
I think an automated alert to notify system admins when an automation on a sheet is turned off would be a good feature. We have had them accidentally turned off, or on purpose sometimes even, when they didn't need to be.
-
Can an error message generated by a formula be used to trigger a workflow?
I've seen suggestions in other forum posts that this does not work, but nothing conclusive. I have an index/match formula to link data from sheet 1 to sheet 2. If the indexed row in sheet 1 is later deleted (the project is cancelled, for instance) there is no longer a match and I get a #NO MATCH error in sheet 2. I want to…
-
copy row to intermediate and back to original sheet - with NEW automated number
I'm trying to copy a row from my primary list to an intermediate list and then back to the original list with a new auto-generated number. Right now, the row copies back over to the original list with the SAME auto-generated number, which now shows a duplicate value. Any way to trigger a new auto-generated number on the…
-
How to remove my name in mails
hi, below my name come when notification send to end users... I am owner of this project and developed for some other team... hot to remove my name in notifications mails...
-
CA not receiving notifications not being released at all, not working for runflow
Our Contract Admin (CA) receives notifications for their monitors who have completed preliminary approvals for their agencies. We created automation where the CA would receive a notification when every monitor receives a submission. Workflow is not working, and CA isn't receiving email notifications but is receiving a few…
