-
RYGB #unparseable
I have tried multiple formula listed on the community to automate the RYG column and i keep getting the unparseable error. I just need a formula to be able to show a red ball if the finish date has passed, Green if it completed, yellow if it is in progress and it is today.
-
Auto Numbering / System
Hi, I am wondering is there a way to have an auto numbering column where the display format is dependant on the value of another column. I have a "Type" column that is a dropdown with "Action" and "Decision" as the values. I would like the Auto number to display A-001 if this column is "Action" and D-001 if it…
-
Embed YELP! review sites
I am trying to set up a dashboard that shows our Yelp! reviews through the embed widget. The embed code from the biz yelp page and the public one from yelp.com for reviews don't work. Has anyone else been able to do this?
-
Consolidate Metrics from multiple existing and new sheets
Hey Everybody, We currently have multiple workspaces for each individual job that we do. Each job will have its own Metrics sheet that brings data from the other sheets for progress. As new jobs come in, new workspaces are created. I am looking for a way to be able to create a high level Metrics sheet that can look at all…
-
Project Rollup Metrics (sum of all project durations)
I have a master sheet that rolls up metrics from my projects for reporting on various KPIs to my leadership. I need to sum duration, but when I link the cell from the sheet it comes over as (ex., 43d). The sum doesn't acknowledge the d, so I am unable to sum the total of all days for a project. Thanks,
-
Automation - Copy Row(s) to another Sheet
The new automation feature "move row" is fantastic and has improved over processing of manual tasks. Has there been thought or a plan to release an automated "copy row" function? This would be extremely helpful for reoccurring tasks that are frequency dependent.
-
Automated Workflow vs Reminders
I want to be able to have emails automatically be sent out 30 days prior to xx date for a sheet. I've been playing with the workflows and can get it to work but it needs a trigger. Whereas the "set reminder" can do what I want without a trigger but only goes out 14 days. Is there a way to get email notices based only on a…
-
Workflow issue
I have created a workflow that seems simple enough. I am using it to approve document changes. The trigger block is the date change (Revision date). The "Other" is if the Supervisor Dept has not been selected, it would Request an Update from specific personnel. However, I made some updates to a sheet. The trigger for…
-
Compare/Track planned dates vs actual dates
Hello, I would like to find the best way to track our time slippage in projects. Each project (sheet) in Smartsheet is essentially a big timing plan. However, things don't often go to according to original plans, and the dates have to unfortunately change often. I would like to be able to track how these dates changed, so…
-
Have automation send individualized emails
Hello, We use automations to send emails to a department when it reaches a certain point. They need an individual email sent since they are able to put that into their ticket system and handle each request individually. However, we had a group of emails go at the same time and it sent as one comprehensive email which they…
