-
Tracking time
Is there are way to track the amount of time each stage of development takes? What formula would I use and then, what chart?
-
Need a formula to have all work-flowed moved cells to go to the top of the sheet
Every time I put an automation to move cells to another sheet, they end up at the bottom of the new sheet. Is there a formula I can use so that they can start coming in at the top? Thank you!
-
How to create a deadline column for it to be three days before the deadline that was put in the form
I am trying to create a workflow (I think) that when someone completes my form and enters their requested deadline in the form, there will be an automatic column that will show three days before that deadline requested. I want that date to automatically show three days before the requested deadline so that we can get…
-
Map proofing data with proof info columns is not available
Hello, I have an enterprise license and am the owner of the sheet. I want to map proofing data with proof info columns (per this article). I would like to do this so the team sees the proof status at a glance. I do not have the option "Create Proof Info Column" in the proofing panel, as the article states. Am I missing…
-
Generate Cover Sheet Summary Page off of Data?
We have a spreadsheet listing all of our jobs and I was wondering if anyone knows if we can highlight one of the jobs by selecting it and generating a cover page summary report of just that one job? Any advice would be greatly appreciated! Thanks, Crystal
-
Free Webinar: Collaborate on Content with Proofing
Join us January 27th for our webinar "Collaborate on Content with Proofing." On this webinar you will learn how your team can review and approve content with Smartsheet Proofing. We will be hosting 3 sessions across multiple timezones, if you are not able to join us live, feel free to still register and we will share the…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Lead Tracking In Smartsheet
I need to be able to track leads sources in Smartsheet. There is currently no ability to passthrough the URL of the embedded page for UTM parameters. None of the options for fields support scripts to manually pull that URL for example; <script> document.getElementById("demo").innerHTML = "The full URL of this page is:<br>"…
-
Pass URL parameters from web ad campaign into Form hidden values
I am running an advertising campaign to get registrations on my Form. When the users click on the advertisement (either ad A or ad B) , they go to a landing page with a URL ending in -----.com/?campaign=launch&utm_source=ad_a , and the form is on that landing page. Parameters are key-value pairs that can appear inside URL…
-
On-Demand Webinar: 5 Strategies for a Powerful Content Calendar
Missed the webinar? Recording available here. 5 Strategies for a Powerful Content Calendar In this webinar, we'll share strategies for using Smartsheet to align your teams across a real-time content calendar, including: - Visualization: Customize, organize, and sync your content plan to Smartsheet, Google, or other…
