-
How do I create an IF functions that will change my status color if information is in the cell
I am trying to have my event status which is (symbols) update to gray, red, yellow, or green depending on if 2 cells contain information (Green), or one cell or no cells have information and is more than two weeks from the date (yellow), one or no cells have information and is less than two weeks from the date or event is…
-
Merged: Approval Flow support more than two buttons
This discussion has been merged.
-
Is an automated export of a Smartsheet to an Excel file possible?
Hi all, I have been having the most frustrating conversation with Smartsheet support on this topic and not getting answers to the question that I asked. I would like to set up an automation that will email me an Excel copy of my project plans on a weekly basis (or when triggered with a change - I don't really care) as I…
-
Can I create an automation on a template in a toolkit?
Hello Smartsheet Community! My question is: Can I create an automation (e.g. to notify someone with a specific message) on a template in a toolkit that will carry over when new projects are created?
-
Merged: Updating distribution list for Auto delivered reports
This discussion has been merged.
-
Automation Error - Notifications
I'm having an issue with my notification workflows when someone submits a new request through a form I created. I recently updated the 'Submitted By" field on the form to a drop down option so those submitting new requests can type their name and their email address auto populates. Previously, the field was left as open…
-
Automatically Update Numbers in Countdown Formula
Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.
-
Copy updated cell values of one sheet to another
Hi, I have two sheets with exact same columns. When any cell(s) value of row in sheet 1 is updated, then I want to update same row with unique identifier ID if existing in sheet 2 to be updated with new cell values as well. Please help how it can be accomplished. Example: Let say Price Per unit of Row 3 is changed in first…
-
Is it possible to make a work flow app
Hello, I am wondering if it is possible to create a workflow app that takes data from my sheet, and based on the value of one cell in a column, makes that row visible to another user so they know they need to complete that rows "job", and then with a click of a button on their part, mark it as complete, and it then moves…
-
Auto check all check boxes in a column
Hello! I have a sheet with a check box column where end users select the check box to nominate a speaker which will trigger a separate workflow. The issue with individually selecting is that there can be upwards of 100 speakers on the list. Is there a way to have an option for the end user to click one check box or choose…
