-
Is there a formula that shows ratios from two cells?
I am trying to show a ratio on my dashboard and would like to know if I could use a function to find the ratio.
-
How can I count the amount of actions in a certain weekday?
Hi all! I'm trying to setup a formula that allows me to count actions (in red) and that also shows me the weekday in which they were made. The columns I'm using for this are 'S' and 'Action Creation Date'. My formula is currently the following: =COUNTIFS(S:S, "Red", [Action Creation Date]:[Action Creation Date], [Action…
-
Reports: GROUP BY <VALUE> and Parent/Child Hierarchy
Question 1: I'm pulling multiple reports together. I can't figure out how to issue any sort of GROUP BY clause. Please tell me how. Question 2: How do I pull Parent/Child meaningfully into a report? It doesn't seem to honor the relationship any time I sort.
-
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…