-
Possible to create a URL/Hyperlink for new item (Automatically)?
We would like to create a URL/Hyperlink for new item automatically...in the attached example I had to 1) Manually go to row, 2) Select Properties, 3) Copy the Row Link, 4) Paste the Row Link in the field. We would like this to happen automatically, so far everything I have read says it is not possible. Someone have a…
-
Merged: Include column description in Report
This discussion has been merged.
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Sheet Filters on Reports
Sheet filters are extremely useful ways to view sheet information, it would useful to have the ability to select a sheet filter when developing a report to avoid having to duplicate the filter setup process.
-
Schedule Health Balls Change Based on End Date and Status
I'm looking to have the schedule health balls change color based on the "Status" and "End Date" columns. Green = "Complete" OR "In Progress" with more than 2 days to "End Date" Yellow = "In Progress" with 0-2 days to "End Date" OR "On Hold" Red = Not "Complete" after the "End Date" Thank you!
-
How to track training hours across an organization
Hi, I need suggestions for how to track training hours for all employees. Each employee has a separate training sheet - it's broken out by training section with training items underneath. One of the columns on this sheet is Duration - this is used to track how many hours are needed for that training task. I need to create…
-
Formula does not appear to be working
Okay, first, here is my formula: =IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1)) It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a…
-
Duration and Predecessors: What to do when you have 1000s of rows?
Hi there, I have a sheet that contains original data as well as data imported from CSV files. We have a template that we use to copy the CSV data from different external sources. This template contains pre-built tasks and milestones, like this: The dates come in as TBD and the hierarchy is flat (no parent and child rows).…
-
Automatic Report for Multiple Ssheets
Olá comunidades, espero que estejam bem. I have a question about an action. I would like to generate a report for all my project spreadsheets. However, I need to manually insert the spreadsheets into the report, and due to the large number of projects, I would like to know if there is a way to do this automatically? Here…
-
Generate Documents - Pull only the dates into a PDF Not times
Hello Smartsheet Community, I'm encountering an issue while generating a document from my Smartsheet. I have a column containing dates, but when I generate documents (a PDF), it includes both the dates and times. However, I only want to include the dates without the times in the generated document. Could someone please…