-
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…
-
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…
-
Send - Function/Option
i was really hoping this was not going to happen. I have worksheets set up (at 14 facilities) to be able to "send" the row to themselves and then to the customer. I REALLY need this function back. I need users to be able to do this.
-
Moving Row Automation - Not Working?
Hi there, I was super excited to see some of the new features that were released this week, specifically the automation to move rows!!! I set up the workflow automation according to the SOP from Smartsheet, but it is not working (at all). Not one line has moved yet... any suggestions/advice as to why? Thank you, appreciate…
-
Show dates beyond 90 days
We need to report on Jobs that has not been touched in the last 90 days. When we start a new Job we copy 4 "template" rows which include dates in the future. When I run my current report, it looks for dates on the parent row, but this row is showing the oldest date for the children. If a job has not been touched for over…
-
Disable attachments in a Report
I have a large smartsheet of all of our Part Numbers. I also use this as a database for pulling several different reports. One report I publish on the web is our price list for all of our dealers to access. Now I am looking at attaching the print to each row. My external consultant partners need the full print, but I don't…
-
Row Locking Now Requires Paid User
For the past 3 years I have had free license users managing a sheet and locking rows. Seems as of yesterday they lost the ability to lock rows and the annotation states that they need to upgrade to a paid user in order to do so. Can someone confirm this is the new normal? Maybe provide a link to a announcement that states…
-
SUMIFS looking for specific phrase
Hi Community, I've been digging to find an answer for sometime now and haven't been able to find what I am looking for quite yet. What I need my formula to do is to search for a particular phrase and then sum the values on that same row if that phrase is found. There are four columns in which that phrase could be found,…
-
Stuck on a formula involving dates
Hello formula gods, I need your help once again. :-) I'm trying to write a formula that looks at 3 different date columns. 1. Look at the 1. actual completion date, if not blank then make it green, if it is blank then look at the revised due date column, if not blank then red for past due or yellow for reminder, if…
-
RYG Symbols from 3 Columns
I am trying to return a RYG symbol based on 3 different columns(Decision) Approved, Needs Additional Information (Denied), or Submitted. Based on these 3 columns data, if any of them say "Need Additional Information", I'd like the Symbol (Status) Column to be the Red Symbol, however if all 3 Decision Columns are "Approved"…