-
Updating RYGB status based on date AND dropdown selection in multiple columns
Hello! I would like for the RYGB status to be updated based on BOTH a due date (I already know how to do the status based on only due date), AND on the selection of a drop down menu in 5 other columns. So: Red is past due AND "completed" or "N/A" are not selected in the drop down menu in multiple columns. Green is past due…
-
Summary of lacking features
After running a project with multiple sub-projects since june last year, project is preparing/renovation of a eight-floor building for 1300 workers including construction, painting, electrical, lighting, IT, AV, the top three features I have been missing are (no ranking between them): 1. Baseline functionality 2. Ability…
-
New Row Formula Issues/ Default New Row Feature?
I'm looking to take a Smartsheet I created for my department and to share it with other teams. It's fairly simple, but I have a few formulas doing some stuff: * A Status Ball that syncs with the status text. * A formula in a PARENT_PROJECT =(PARENT([Project]@row)) that syncs with the Parent Project name so that I can use…
-
Hyperlink to a server (referencing cells that tell it where on the server it is)
Good morning, When I use excel, I have the ability to combine several cells together using the "HYPERLINK" formula, and am able to get a link generated automatically where it will point to an outside server and folder I'm working with. Excel does it perfectly, but I'm using SS to track things within a team. But it's 2…
-
% Rool-Upon another sheet
I have created a construction schedule where i have many lines of of tasks that apply in a mixed format to different subcontractors. Each task has it own % value. I have created another sheet where I have listed the Subcontractors and am trying to roll up the %of every line (associated with a specific subcontractor into a…
-
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…
-
Adjusting trip start/end date based on certain members holidays
Hi everybody, I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do. I volunteer for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our members are college students with varying schedules and holidays planned. (I already have…
-
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
-
I can't see/manage my Alerts & Actions
Hello, I have a problem concerning Alerts & Actions. When i first press it in the toolbar I can see that I have 10 Rules. But I can not go further to manage them. Anyone experienced the same problem?
-
Sending Email as an Attachment
I have an email scheduled to send a sheet as attachment. I've selected excel as the document type, however after I add the schedule, it changes back to PDF and when it sends it goes as PDF. How do you make it stay with excel as the document type?
