-
Report sorting - needing more than 3 sorts
Good afternoon, I have several reports that I am limited in displaying correctly since the sort option only allows for a maximum of three. Is there a plan to increase the number? I tried the Summary and Grouping options and it makes the report too clunky. I just need a streamlined sort with more sort options. ;) Blessings,…
-
COUNTIFS for Previous Month Data
I am trying to create a metric for a Dashboard and need a count of items that were submitted the month before current. I am using as reference "{HDP Late Add Request Request Date}" column. I am currently counting the metrics for the current month and the formula is working. I am not sure where to add the criteria to the…
-
Need formula that will look up a cell in another column, if true return "Complete", if not "Waiting"
This is the formula that works in excel - I cannot replicate in Smartsheet Essential what I need is If the item in column A is in Column B return "Complete" if not return "Waiting" '=IF(IFNA((VLOOKUP(A2,'[Win 11 Upgraded Assets.xlsx]CDN All Windows 11 23H2 Workst'!A$1:A$3700,1,FALSE))," ")=" ","Waiting","Complete")
-
How can I display data horizontally from data in a row format
I have metric data on a project that I am capturing weekly that I would like to view horizontally week over week for the current month. I'd like to do this dynamically so I can pull the data into a dashboard. This is what I have in my metrics sheet: This is how I would like the data displayed: Any advice you can provide to…
-
Send Row function Not available in WorkApps Report
I am not sure if this is intentional but we cannot use the send row function form a report linked to a WorkApp. I am able to send row from the same report when I access it through the workspace, but when I navigate through the WorkApp it does not exist. Is there a way around this or can I do anything to change this? It is…
-
How can I write a formula to reference multiple dependencies and fill in specific results?
I'm looking to write a function to improve a very manual event staffing procedure. I have a sheet that has staff member names in rows and columns showing various skills that are trained in the company. If there is an "x" in a cell under a skill it means the staff member in that row is trained on that skill. We have a…
-
Weekending Thought: Filter or Formula?
Anyone else ever have this thought when designing/building a solution? I tend to draft out different scenarios on a piece of paper and test them in Smartsheet to document the outcomes. What is a good practice you apply when designing/building your Smartsheet solution for yourself or clients?
-
Dashboard sharing options
Hi, I was wondering when the dashboard sharing option changed. We used to share people as editor and now we can only share as admin or viewer! Thank you
-
Sorting Queried Data in Descending Order
Hi Everyone, I was wondering if there is a way to sort queried data in descending order. I'm aware there is no explicit SORT function and the way I set up my data sheet, I am unable to sort the rows/columns that way. The formula I am using is as follows: =JOIN(COLLECT({Domain}, {Status}, "DONE"), CHAR(10)) This is…
-
Smartsheet Report
Hello, I am building a row report and I am running into some roadblocks. I am trying to show the number of client requests we received in the last seven days, how many we resolved in the last seven days, how many cases we still have open, how many have been still open (pending) in 15 days or more, and how many are pending…
