-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
How can i archive workspace?
So we have created sperate workspace for different projects. And we would like to archive that workspace once the project is done. Is there anyway we can archive it? If not, any other solution people are utilizing? Appreciate the help :)
-
I'm just stumped on this date function. Can someone help me please?
I have a sheet that is tracking projects for our team. I have one column that is "Asset Due Date" and I want another column "TD Due Date" to auto populate a date that is 28 days prior to the date chosen for "Asset Due Date". Both columns are set up as date column types. I've played with the date function and just can't…
-
Links to Attachments
How long does the link to an attachment in an automated email last?
-
Workflow in Parallel not sequence
To limit the amount of workflows, I was hoping to create a workflow that has 1 trigger but many actions that happen at the same time. Rather than waiting for the pervious one to happen. Currently my workflow looks like the brown example, and only sends the first request all the way at the left.
-
Error: Trigger Alert Someone workflow on a daily or weekly basis.
Can someone explain to me why this automation works: But this automation throws an error: The error occurs when I try to change the trigger to "daily" or "weekly". The error is as follows: According to this smartsheet article, there should be no problem with this workflow: Trigger frequent, change-based automations in…
-
Approval Flow Log
Is there anyway I can get an approval record for my approval flow? I have an approval flow with 5 steps, each triggered to start after the previous one changes from "submitted" to "approved", each time a time is recorded. At the end I would like to have something like the DocuSign summary, or Certificate of Completion... a…
-
2 Workflows Being Triggered When Only 1 Should Be
Good afternoon! I have a use case where when a new record is created and the "team leader" field changes from blank to populated, I want to send an alert to someone. I want to send a separate alert when the "team leader" field value changes. On first glance, I thought I would easily set two separate workflows up, one with…
-
Approval Workflow - Request approval from a pre-defined contact in a sheet
I have a use case where the approver for something will not always be the same individual. I would like to add a column for the approver (contacts list), and have an automated approval workflow that sends an approval request to the individual listed in that column. Smartsheet seems to require that I specify a single…
-
All sheets gone but the templates left
I am a licensed user. I logged in to the Smartsheet today and found all the sheets I had are gone. No matter whether shared or unshared they disappeared, even the workspace I created for my team. the only thing I have on my Sheet page is some templates I used for tests long ago. I am not sure what is going on. But that led…