-
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
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
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.