-
Where has Create a new sheet gone??
Hi The option to create a new sheet just a plain sheet has gone from the Home screen. Now all you have is "Solutions" or Grid, Form, Dashboard etc when I do not want anything with anything pre filled just a plain old sheet I can create myself. Why has this disappeared and why is it so hard to find out how to do the…
-
Why doesn't automation work when I use "Send from organization" option?
I have set up a workflow to Alert Someone when triggered. When I change the sender option to "Send from organization" I see my organization name. However, when I test it, I no longer receive a message (workflow doesn't run). If I change it back to "Send from Smartsheet automation" and test it again, it works just fine. The…
-
One weekly automated reminder for workplan and action log - is this possible?
I have automated weekly reminders for tasks on my workplan that are coming due and still "in progress" and I have actions on my action log that also have an automated reminder that goes out once/week for the project. People only want to receive one automated reminder/update 1x/week for the whole project (i.e. not one for…
-
Help Create Metric
Hi, Can someone help me create a formula on my metric sheet. I have two columns i want to include from my sheet one Titled "Project Status" which has drop downs for Where the project is at eg Budget, Won, Lost, the other column is Titled "Total" which has the price of project. What im trying to do is create a formula on…
-
Get Date and Time from a column
I have a spreadsheet, which contains a Check Box type column, when it is selected I needed to save the date and time in another column for SLA, I've tried different ways and none of them work, I thought about copying the line and getting it the modified column, but the problem is that it keeps updating, does anyone know…
-
Automated emails not sending attachments
I am having trouble with Smartsheets not sending not sending attachments. I have it currently set up where I have to approve it before the email gets sent out. Once I approve it I have a separate automation send an email to group 1 or group 2 based on which option they pick in the form. At first I was having trouble with…
-
Identifying and Archiving Duplicate Rows While Retaining the Oldest Entry
I require help in detecting duplicate rows and transferring them to an archive sheet while retaining the oldest entry. Your assistance is highly valued. Thank you!
-
Move Rows Automation Suddenly Failing - Multiple Sheets
Hi. I manage 3 very similar smartsheet tools for 3 different office's training request intake and approval systems. Once requests are approved, an automation has successfully been moving them to each site's Request Archive Sheet. This has worked as expected since March. For some reason today this feature has suddenly and…
-
Hyperlinks and Conditional Formatting on Date
Hello, I know this might be a basic question but since we’re new to Smartsheet, we’d like to kindly ask reason why the conditional formatting to date with hyperlinks does not work? Scenario is, we have conditional formatting to highlight cells with dates of expiry of documents. However, we linked the date to the actual…
-
Workaround for single-use request approval button
I have created an intake form that goes out to multiple people to review and respond with two things: 1) is their area impacted, and 2) if yes, who will be assigned? If they know they are impacted but do not yet know who will be assigned, they can't go back to input the information once known. Any ideas how to get around…