-
Merged: Form to Modify Existing Row
This discussion has been merged.
-
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…
-
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…
