-
Adding Date using 'Today' or 'T'
I just found out that you can use the function 'Today' or just type the letter 'T' in any 'Date field' in smartsheet and it will populate the date. You can also do simple addition or subtraction to calculate for dates. This is on every date field, sheet summary, forms, automation, workflow, rules, send as attachement and…
-
Smartsheet University - Exam Results
Good Morning, I'm looking to find out the specifics of a recent exam I have sat. It failed the exam however it flashed up the specific % per section, just so I know which sections I need to focus my training on? Thanks
-
Can you turn a Dashboard into a template
Hi, Smartsheet community! Im new to Smartsheet but I know all of the amazing things it can do! I was wondering. I have a dashboard format that I like and want to keep using the same format for my project. I have multiple projects that all have the same style of dashboards, sheets & reports. Id like those to be pulled into…
-
Bookend a scheduler task with two predecessors & variable number of days
My smartsheet scheduler task will float between two predecessors… meaning it will start at the same time as one task (i.e. 10SS) and finish in coordination with another predecessor (i.e. 12FF). The number of days will technically be variable and change as the predecessors change. Smartsheet does not seem to allow this, but…
-
Need Help With Setting Up Automation
I can't get this automation to work. I need the Final Approval Box to change to "completed" when all 6 previous columns have the appropriate answers. "Approved" needs to be in the approval columns (3 total) and the sign off columns (3 total) need to contain a text or not be blank. These 6 columns will be filled out by 3…
-
Update Request - Error "Please enter a valid email address."
I was trying to send an update request to an audience of non-users and it kept failing to send to one email address. -My privacy settings were set to not restricted to smartsheet users. -When my work flow failed, I tried manually sending an update request and I kept getting this error. After reaching out to the help team,…
-
Update Sheet/Cell via e-mail
Is there a way that a cell/sheet can be updated from an email? In my search, some seemed to think that a sheet is related to a specific email address, that when emailed with the correct format to declare column/row/cell, the chosen contents would end up on the sheet itself. Is this possible?
-
Subitems "Child Tickets" Automations
Hello, I recently started a new intake system within Smartsheet for our Training team. The way they structure tickets is unique. They have Parent tickets and Child Tickets. The individual requesting assistance from the training team can submit a ticket, but that ticket could have several deliverables . Each deliverable is…
-
Can you save a comment for later?
Hi all, I have noticed that once you read a comment you can't "save" it or mark it as unread. I find this very useful to remind myself of things I can't reply to straight away, but want to go back to. Is there a way to do it that I am missing?
-
Stop Workflow with Action
I keep receiving the reminder notifications for a flow. I added an action at the end of the flow, but I still receive the reminders.