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,…
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…
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…
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
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…
This discussion has been merged.
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…
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…
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…
We have 4 employees that receive daily projects assigned to them. To avoid having the employees viewing their co-workers daily schedule by sharing the project management sheet and doing a filter so they only view their daily projects but can also turn off the filter as they please to see the complete project management…
