-
Problem with average number formula, with certain criteria
Hi All! Im trying to get the average number of a certain range, but only if it meets a certain criteria. I have looked at other examples but somehow i don't get it to work. So I want the average of the blue columns. But only if the Red column is a certain name. And if its possible I want to do the formula on a seperate…
-
IF formula and dates: 'Red' status if the % complete is not 100% and the date is in the past
Hi there, Is it possible to incorporate dates in an IF formula? Essentially I want the RAG status to automatically go to 'Red' if the %complete is not 100% and the date is in the past - how would I go about doing this? Thank you
-
Created time is displaying as Pacific Time in Dashboard
I have created a dashboard and added a report to the dashboard. In the published dashboard, the "Created" time is displaying as 3 hours earlier than what the report and Smartsheet is showing. How can I get the published dashboard report to display the correct timezone as is seen in the actual report and Smartsheet?
-
Membership Report
I have to do a monthly membership report for my clients. Right now we use excel. I'm wanting to use smarsheet and have a dashboard that allows graphs and charts. Does anyone have a template that can share or share ideas?
-
This month or previous month in the Report
Hi, I need would like to have reports where all the result are from "this month" or "previous month" but I don't see such filters in When? Option. Can someone help me with that?
-
Can a user request an Update Request?
I'm using a form to collect shift information from employees (onto a master tracker). This shift information is filtered to 10 different reports, depending on the building and department. I need the user/employee to be able to modify their requested shift after they have submitted. The Update Request feature works but I…
-
Mirroring a Grandchild row cell in the Child row cell based off current week
Hey all, I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance! I have a sheet where I'm tracking historical quote metrics by Sales rep and Week. At the suggestion of…
-
Reproducible Hyperlinks
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I can then save them in their feature (finance, schedule, risk, invoices, cash flow, etc)…
-
Updating a Date Column after another cell is updated.
I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single selection column with several options: Estimating Complete, Quote Sent, and Sale. I…
-
RYGB Symbols Average Formula
I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so far. =IF(COUNTIF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Red")) = 4, "Red",…