-
Auto generating due dates for project management
Hello Smartsheet Community! I am attempting to automate our project management for product launches and I need some help figuring out how to set up automated dates in smartsheet. I'd like to 'plug in' a new date into a cell and have the rest of my action plan dates to automatically update based on the number of days it…
-
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
Cumulative Expense Column for budget restraint checks
Hello I need to have a running total expense column on my smartsheet for budgetary checks. Can someone help me with a solution please? I would like a column that updates with a cumulative $ after I enter an expense amount in another existing column. Thanking you in advance. Lawrie.
-
How do you remove sample data from template sets AND clear out data from 2020 sets to restart 2021
I am brand new to SmartSheet but immediately recognize the template sets as being extremely useful. I am trying to customize the Marketing Shared Services Template set but... in general HOW do you delete the sample data in the template sets so that you can start using what you customize? I can't clear out the Marketing…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…
-
Need ideas for best type of sheet for keeping track of accreditations
I have been tasked with creating a system to keep track of all awards, recognitions, accreditations and designations for a large hospital system with 14 hospitals and two primary affiliates. The system was created two years ago when two hospital systems merged; both systems had experienced their own individual mergers over…
-
Vlookup on reports
Hi I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup? Thanks
-
Auto Save
I just noticed that all of my sheets are now auto saving. When did this start? Not sure if this is a good thing or bad thing.
-
Collect and display nearest dates
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type…
