-
Link to a Dashboard in an automation alert
I am sending out alerts based on a cell being changed. I would like to customize the email that gets sent to include a link to a related dashboard. Is there a way to make this a hyperlink that can just be clicked to take them to that dashboard?
-
Help with formula to populate a quarter (text) based off date field.
Hello! I've searched many posts on the forum and can't find a solution. I'm at my wits end, any help would be very much appreciated! I am looking for a formula that will show a text result of Q#-YYYY based on an entry in a date field ("Expected Delivery Date", which is using the standard SmartSheet Date column. I can't…
-
How to loop through workflow
I'm having a problem creating an approval flow. When the approver denies the flow, it automatically sends an email to the one who requested the approval asking him to clear the wrong field. I need that after the field is arranged the system understands that it should again send an email for approval. I do not want to…
-
Flag overlapping projects based on RYG ball
I've looked and am unsure if smartsheet is even capable of this, but can I turn on a flag based on if a new rows start date falls in between the start date and completion date of any other row? I'm also trying to have it triggered ONLY when the complexity (RYG ball) is red. Am I far off with this formula: =IF(AND([Start…
-
Question regarding guest accounts
Hi All, I am a member of my organizations IT Support team and I am currently researching an issue reported by one of our internal users: We have a user outside of our organization that has been invited to work on some smartsheet documents with some of our users. I believe this is through a guest account that was given…
-
Importing\Uploading Information
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just…
-
Automate RYG Balls based on % complete and start and end dates
I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date…
-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…
-
Sharing an alternative email address
I usually "recycle" email addreses to avoid license payments. For example: normalemail@test.com and the recycled one would be, normalemail+alt@test.com Gmail allow that, and it eases some automatic activities. Anyways, when I am trying to share a sheet in smartsheets, the system does not allow to do that, and alerts that…
-
Recording the date of a specific update and locking that date?
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…