-
Removing row data from update request email
For security concerns, we would like not to have the row data emailed in an Update Request. I will interpolate the context of the row in the email myself so would only need the subject and body of the email sent, along with the link to the update form. Any help is appreciated. Thank you.
-
Gantt zoom to current day (centered) on open?
Hello, Is there a setting to set the current day to be centered in the gantt view when I open my sheet? I always have to scroll over to the current day on long projects. Thanks, Phil
-
Can approvers of Smartsheet forms be added without giving access to the sheet?
I am creating a form in Smarthsheet that will require two levels of approval is a particular question is answered in a certain way. In the form they manually enter the email address of the people who are required for approval. I am finding that if I do not share the sheet with the person I am seeking approval from I cannot…
-
Bug: Formula not accurate for Viewer Only
Didn't see an official bug report page, so I hope it's OK here. I've built a formula for a parent row to count orbs in children rows and display red > yellow > green, so if at least one red, the parent shows red, if at least one yellow, parent shows yellow. =IF(COUNTIF(CHILDREN(Progress@row), "Red") > 0, "Red",…
-
Employee Verification/Consent/Sign Off
Hello: I am looking for a streamlined solution that will allow us to obtain employee verification/sign-off acknowleding they've reviewed a document. Does SmartSheets have a template that will allow you to import your employee listing to allow them to sign-off and monitor responses? Would be great if reminders could be sent…
-
Need to transfer file ownership - Smartsheet won't let me!
Hello, I created a draft version of a workspace, now I need to transfer it to a licensed user and I get: "You have exceeded the maximum number of emails that your account can send" How can I get this fixed???? Thanks Karen
-
Formatting Cells with Color
Hey All, Question for ya! Hoping someone can solve this for me. I have created conditional formatting to turn a cell GREEN if a date in a cell falls ahead of a projected date, RED if a date in a cell falls after a projected date, and BLUE if a date lands exactly the same date as the projected date. Here is the formula i…
-
Automated update request not working
Hi, We are creating an automated workflow that requests an update thru a specific mail and it does not seem to work. Automated approval workflows work perfectly but update requests don't send the appropriate mail requested (eventhough in the sheet you can see that there's an update requested). Can you please help? Thanks…
-
Cell Linking Modified Date
I have a main sheet I use to gather information from underlying, linked sheets. Is there a way to get my base sheet to update with modified by date of those underlying sheets? (i.e. I have one sheet I use to roll up information from more detailed project plans that are linked. When those project plans are updated, is there…
-
Standard Milestone Names
I am creating a project template for my department to use for all projects. I have created drop menus to limit certain column entries to a controlled list of choices. I would like to do something similar to control how the user names a milestone. Is there a way to have a list of standard milestone names for the user to…