-
Automatically fill a sheet from a pdf or word doc
I have a word form that one of our teams needs to fill out. They then send me a pdf of the form and I need to enter the data from the form into a Smartsheet log. Is there a way to automatically scan the pdf and enter the data? I can also do it from the word form if needed. Creating the form in Smartsheet directly is not an…
-
Checklist population with info from another sheet
Hi team! I'm hoping one of you wise Smartsheets gurus have some guidance. I am trying to build out a "checklist" that will populate with data from another form and for the life of me I cannot figure it out! For a little more context, I work in the Mortgage industry. The documentation needed for each loan can vary,…
-
Highlight Changes in Report - read the changes from Sheets
Currently highlight changes tool in report only shows changes to cells made within the report, the report doesn't read changed made within the sheets. Request is for the report to read changes made to each of the sheets the report is connected to and show the highlights on the report. This feature would allow a wide group…
-
Project management template packet- Forms Included
Hello, I have generated a 'Project Management Template Packet' to be re-used by Project Managers each time they begin a new construction project. One important item we use is an RFI Form- used by field personnel to generate 'requests for information', which populate a Smartsheet used internally. This information is then…
-
How do you create a formula that calculates weeks out in certain cells based off one cells date?
Hello! I've tried to add a formula to convert an existing column into one with a formula and none are working. I have a target end date and i want existing cells in a "task section" to calculate the weeks out based off that date
-
Count formulae
Hi all, Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations: To calculate the count of 'Medical Device Related' category from the 'Relevant System' column Same as the above but for 'Non-Medical Related' category I want to have a breakdown of the sub-categories for each…
-
Merged: Gantt Timescale Settings
This discussion has been merged.
-
Automatic Predecessor Adjustment
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with the fabrication packages released from the Eng Dept. Sometimes the schedule needs to…
-
hyperlinking to a folder and or file on our local network drive
I would like to hyperlink a folder to our company shared drive from smartsheet. I keep getting the error message "Invalid URL" I have seen from other comments that this is an issue, is this some feature that may be added by smartsheet? It would greatly benefit the way we could use smartsheets. Thanks for your anticipated…
-
Finger gesture scrolling.
We issued Surface Pro 7+’s and Surface Pro 9’s to managers to use in the field now that Smartsheet has become the main system for work orders and assignments. For some reason, when using the browser or app on these devices, we are unable to scroll by touching the screen and swiping up and down or left or right. We can…
