Conditional formatting based on location in hierachy
Please consider incorporating a functions level() and has_cildren() in the conditional formatting and reporting filters. level() would give "0" if top level and "1","2" ... depending on the number of indentations. has_children() retruns true or false. Combined this would allow: - making filtered reports only extracting…
Print report from Project and Task Management Template
Hi, I have created a sheet utilizing the project and task management template and would like to print a report that displays only select columns of the sheet for use during a status meeting. I would like all rows to print, but only some columns. Is there a way to do this? Currently, we are hiding the columns and then…
Row Specific Notifications
Hello, I have a workflow set up that is a set of sequential actions, each with their own row. I'd like to send a specific email to the owner of the next row when the previous is completed. This email is specific to the task on their row. Example: Row 1- Create employee ID Row 2- Grant access to systems Once the employee ID…
Hello, I'm hoping there is a way to "clone" whole sheets, I don't want to re-reference the same sheets over and over again. -Making dashboards for my field teams.
Template Management - Updating Active Projects
Greetings, I saw an older post similar to this subject - but I'll open this one to hopefully garner some fresh information. I use a Template that I've built to start new projects (sheets). On occassion, I'll learn some nifty new feature or functionality that I'll build into my master template. That's great for "from here…
Help! Trying to edit the automation of RYG balls!
Hello All! I am stuck trying to fix the automation of my RYG balls in Smartsheets! I need to add one more IF formula to be the formula below so that if a task has not yet been started, the ball will show up as gray. You can see from the screenshot below that all the other balls are working except when the task has yet to…
Fleet maintenance template
Hi there I am looking for a template to adapt to assist us with machinery maintenance on the farm. I want to be able to record work done and to set reminders for upcoming maintenance tasks. I am sure someone must have already done something similar with smart sheet - any help gladly received. Andrew
Project Cost Calculator Smartsheet
I am looking for a template in smartsheet that I can use to build costs for projects and training courses we conduct. I noticed that on the smartsheet website advertisement it says that smartsheet has the solution. My goal is to program some of our costs to do business with certain rates and then send forms to the Program…
Can cell data create a row?
Let's see if I can properly explain my question! I'm using the Meeting Agenda template to create and track agenda items. I'm then using that sheet to add notes to each agenda item during the meeting. I would like to use a modified version of the Agenda Item Follow Up template to turn any of those agenda items (from Meeting…
Tracking time in forms
Good afternoon, We are creating a form/sheet to track our deliveries to job sites. We want our driver to be able to log the time he arrives on site and the time he leaves. Is there a time feature we can use for forms? Thanks