-
Updating a Timestamp
Hello, I have some historical data that I uploaded into my sheet that I need to change the auto timestamp for so my calculations are accurate. Is there a way to update a cell with a timestamp in it? It won't let me update it at all... thanks!
-
is there a formula that sum only for direct children
if I have a project and this project has task and the task have sub task the hierocracy will be the project is the parent, the task will be children for the project, the sub task will be children for task I want a formula that I apply in the project row that is going to sum the utilization percentage from tasks only…
-
Alert someone
I have a user who assigned someone to a task but when she tries to add him to the Alert Someone-Alert a specific user, his name is not showing in the list. When I try the same, his name is displaying for me. She has other users assigned to tasks in the sheet and was able to add them to the Alerts. She has closed/reopened…
-
Alert Triggers?
Good afternoon, everyone! I had a quick question about automation for a Smartsheet form. I set up a workflow to be triggered when a date is reached (today- 3/29) and repeating every week on Tuesday starting on 03/29 and ending on 04/13. The alert is set to go to specific people (including myself) at a specific time (9 am…
-
Include sheet link in automatic update request
Hi. I use the Teams bot. I am setting workflow to generate an update request at the end date of a task. When the notification appears, it takes me to an online form. I can: check the "done" box change the task name I cannot: change the end date see a URL anywhere to get to the sheet, nor can I include this in the…
-
How do I send an attached document in a workflow?
Hi there, My clients need to complete an intake form. Once the form is submitted, a workflow kicks in and sends an email to the client's email address. With this mail, I want to attach any document that can be sent with the mail from the workflow. How do I get this setup correctly?
-
Dashboard Form Link Icon
This happened once automatically without me doing anything special, but I can't seem to reproduce it. On a project dashboard, when I created a link to a Smartsheet form, Smartsheet recognized it as a form link and gave me a nice icon. Was this feature introduced and then quickly removed, or something? Anybody know how to…
-
Help with Workflow.
I am having some issues with an automation workflow. I am copying info from one sheet to another using automation workflow. I want the user who is inputting the info to be displayed on the receiving sheet (sheet where info is copied). The receiving sheet however displays smartsheet@automation.com. How do I get their email…
-
Using Smartsheet for a test series?
I would love to explore if I can use Smartsheet for a end-to-end test series: As a product manager, I like to provide a set of information pieces to several downstream systems for validation. The first downstream system should be able to see the information that I provided use it to validate and then enter a pass/fail…
-
Recurring Dates in Routine Task List
I'm hoping one of you could help. I'm currently making a daily 2 week routine task list and would like each date in the due date column to automatically update upon the end of the 2 week routine. I have tried a workflow with a trigger to record a date. However, this changes the column into one date. Any suggestions for…
