-
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…
-
Is it possible to have a form feed into two different sheets?
Is it possible to have a form feed into two different sheets? And if so, is it possible to automate that the "status" column is cell linked to one of those sheets?
-
Merged: Provide Sheet Usage Statistics
This discussion has been merged.
-
Color Coding Calendars - Different Colors for Different Calendars, but from the same sheets?
Hello! I have a workspace with a ton of different sheets that each represent a project timeline for a single client. We are creating different reports to pull together program/client level views for things like team PTO, client due dates, internal resourcing priorities, etc. We use the calendar view of our reports…
-
Trigger a workflow based on Sheet Summary Change (Bridge & Sheet Automations)
It would be nice if we were natively able to trigger an automation based on a change in sheet summary. I would like to be able to set this trigger up in Bridge, along with the ability to do this in regular sheet automations as well.
-
Automation of Update Requests
My team each has a sheet on which they need to ask faculty preferences. I have built out an automation to send the request. When it sends, it sends the request for all the rows, not just select ones. However, testing the automation allows me to select which rows I want to send. How do I build this into the automation?
