-
Automation for expiring dates
Hello, I'm trying to create an automation for a coloum of expiring dates. Each row is associated with a different email, so when the date for their insurance is expiring in two week I would like to sent out an automatic notification to that email address associated with that row. Is this possible?
-
Auto fill information in sheet when a check box is checked in a different sheet
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet. When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in…
-
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
-
Connect email notification with smartsheet for specific users
Hello, i was looking to create a new project using smartsheet to receive alerts from specific email addresses and to log the activities into smartsheet, those notifications will be received by specific users (their email addresses). how i can start implementing that and is it doable or not? Thanks!
-
RYG balls formula displaying text only
I've read through all the replies on this but have not found the resolution yet I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date. The new column Properties is RYG Balls The formula works, but only shows as text Formula i created: =IF(Status@row = "Complete",…
-
Dynamic View: Give access for requestors via their email address
Hi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while handing in the request and then they have to login in to status view with this email…
-
Identify duplicate dates and exclude blank cells
I am working with a SmartSheet that is used by multiple people to schedule meetings. I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)". Dates are entered in rows 7-28. I have added a checkbox column titled "Duplicate Date" to be checked if a…
-
Populating a Second Sheet
I have a form created for a sheet so that when it is submitted it adds a row to Sheet 1. How do I have a second sheet recognize that a new row has been added to Sheet 1 so that it can pull data from a few of the columns? Thank you, Matt
-
QBO and Smartsheet
Is there a way to link an invoice from QBO to a field in Smartsheet?
-
Status for At Risk tasks due in 7 days
I have 4 status categories for my project with respective RYGB balls: * Complete (blue) * At Risk (red) * Requires Attention (yellow) * On Track (green) My current formula in the Health column automatically changes the RYGB balls when the status is changed manually: =IF(Status2 = "On Track", "Green", IF(Status2 =…
