-
RYG symbols return date in different column
Okay so I'm almost done with my project but I ran into a snag and needed some advice. Basically what I'm trying to do is that when I pick the Green symbol todays date is input into the date column, Yellow = todays date in MISC column and leaves the previous date in the Date column. I've programmed for the green but every…
-
Quickest way to update a recurring report's filters
I have a report that I update each week. the "When" section has 7 or 8 lines where the between dates need to be updated. Is there a way to automate this or does it really have to be done manually? Thanks for your input! Jennie
-
Managing Multiple Audit Sheets
I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria and yields a single score on the top parent row showing plant, audit, date, and score. Since there are multiple plants,…
-
Update a cell in a column with data from a different columns
Hi, I'm trying to select a range for the completion status and also trying to refer to a different column and get the data updated in a different column. I'm sure I'm doing something wrong here. Please help me! =IF(COUNTIF([Completion Status]3:[Completion Status]38, 0) > 0.5, "Not Completed", "Pending Mgmt Approval",…
-
Report Notifications
Is there a way to create a notification within a report once it reaches a set amount of rows? I’m using the report for scheduling purposes and would like to know when a certain is reached.
-
Best practice question
Hello, I'm new to Smartsheet as of this week and am getting the hang of things, so please bear with me: What I have: * Large datacenter project involving nine teams* technology inventory for each team * Risk Register report * Migration scheduling report * Dashboard for project health specific to their team What I want to…
-
Graphs 2 variables
Hi I wanted to know if anybody had tried to this type of graph in Samrthseet and if it's possible? Thank you for your help!
-
Preserving Indents when running a Smartsheet Report
Hi, I currenlty have a smartsheet with a bunch of tasks broken out into different sections. I separate the sections with different field values but to help with readability- I also do indenting in the task description field- this allows for the summary tasks to show as bolded. My issue is when I run a report to show a…
-
Report On Dashboard Split With Gantt View
Some how one of the reports on my dashboard is being split with what looks to be the gantt view. I'm not sure why my report is populating this way on the dashboard beause I have never used the gantt view in the report. Anyone know how to fix this? I attached a photo to show what I'm talking about.
-
Best method to update a project sheet
Hello everyone! I'm a project coordinator at a company specialized in manufacturing and installing irrigation systems, we have over 50 projects going on at the same time. We're trying Smartsheet to check whether it suits our needs, we're looking for a way to let a user supervising the project to update the progress…
