-
Cross referencing same range across multiple sheets
I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line of the Program Data sheet to call out (e.g. Start Date, Team Lead 1, Team Lead 2, Team Lead 3, ...). I can't find a way to link each cell without…
-
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…
