-
Dependencies- Start and End Date help
I am trying to automate the start and end date of Task #2 from Task #1. I have enabled dependencies in Smartsheet. Here is the order of events- A deal closes on 9/29 (task #1/row #1), and then I need to do a knowledge transfer for 4 days from 9/30-10/3 (task #2/row #2) For example: Under the "Predecessor" column on row #2,…
-
Need help with a formula!
Hi community, I could use help with a formula. I have a sheet that has all of our Claims data (types, dates, etc) and then a separate sheet that identifies the different claim fees per type of claim. I am trying to have each claim reference the Per Claim Fees sheet to take the type of claim (Auto, Workers Comp, General…
-
Where has my automation gone?!
Hello I've inherited some sheets from a colleague. When they handed them over, there were a number of automations set up on a sheet as well as a dashboard. Today, I've viewed the sheet. There are no automations and the dashboard is asking me to add my first widget. Where has it all gone?! I've tried the Activity log for…
-
How can I use a calculated duration that uses my own formula?
I want to use my own formula to calculate duration. I've added a Calculated Duration column, but I can't select that column in my project settings. What governs what column you can select for your duration column?
-
2024 Calendar template
I'm new to Smartsheets Has anyone created a 2024 Calendar template for their company dashboard that they are posting multiple daily events with the starting time? Willing to share the template?
-
Copy Sheet Name Hyperlinks to Another Sheet
Hello Community - Has anyone found a way to copy the contents of the SHEET NAME column in a report to another Smartsheet? I was able to do it with Data Mesh but it just delivers the text content, not the hyperlink
-
Shortcut Widget for Folders
Help! I am trying to build out a dashboard with a Shortcut Widget to multiple project folders that hold different sheets. I don't want to link directly to the sheets, more so, I would like the shortcut to direct the user to the project folder. Whenever I click on the folder icon in the Widget, nothing populates! I've done…
-
Automation: Generate a Document (Mapping to Sheet ROWS vs. a Column)???
We would like to map a document (from Generate a Document via Automation) to a Sheet with data in ROWS vs. columns. Is that even possible...seems like we are trying to do something it is not designed to do. So in this example it is Project Name, Number, Description, Type, Region, etc..... Any/all assistance is appreciated,…
-
Is there a way to have Smartsheet generate a list of barcodes to print out?
I need to make the labels for an inventory sheet and wanted to see if smartsheet could generate a sheet of them and I can print them out. I need to do it for 4-5 thousand labels
-
How long does it take for support to answer and resolve?
I have a user with an email change, but SmartSheet is not letting me add her correct email as an alternate (which you have to do before you make it primary which is a PITA) because I get an error that the email address is already in use. The "already in use" happened her first day on the job when she used the wrong email…