-
Workaround for Voting
Hello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have a link to a dashboard where they could look at requests that have already been…
-
Automating RYG if a date is too far past another
I have two columns "Date 1" and "Date 2", I want to have a formula for the status column using the RYG Status balls that will: - Green if Date 2 is less or equal to 10 days past Date 1 - Red if Date 2 is more than 10 days past Date 1 Please help
-
Notification when a task has been re-assigned
Hello, I currently have a workflow that notifies individuals when a task has been assigned to them. Is there any way to create an alert if a task is removed/ re-assigned from them? for example task assigned to A is now assigned to B. Can A receive a notification that this is no longer their assignment? I looked through the…
-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
-
Automating a daisy-chain of tasks with Updates and Status
Currently stuck trying to automate the completion of one task to trigger the next. The situation: All data is on one row per project. Each task is listed there and on its own sheet. And everything needs to work through Update Requests. No one should be touching the raw data on the Master Sheet. Form submits a new row on…
-
Don't group friendly reminders
Hi, When a user has 3 requests that are over due , the user now receives one mail with all 3 lines in the mail. Also with a link to the sheet, but when the user tries to open this link he receives the message to request access to this sheet. what I want is that with a reminder the user receives the same mail as originally…
-
Parent worksheet shared automation notification
Hi, our organization would like a notification to power users if the entire workspace is shared by mistake. How can we do this given the Automation inside 1 specific sheet only addresses that sheet sharing?
-
Alert automation stopped working - anyone else experience this?
This automation has stopped working for me. (April 6, 2022) Is anyone else experiencing the Alert automation not sending out alerts? Any ideas how I can kickstart it back into action? (I've opened a request with Smartsheet as well)
-
Way to automate check boxes in a form?
Hello, I have a form with multiple check boxes for people to check off based on which option they want (they can select multiple or just one). I want to be able to have an ALL OF THE ABOVE option but want to find a way so that when a user of the form checks ALL OF THE ABOVE, it will automatically generate all the other…
-
Move Attachments Only sheets to sheets
From reading other posts I don't think this is possible.... is there a way to copy only the attachment from one sheet to another? I do not want to copy rows. Enhancement request for this function please!