-
Can I request an input variable
Hi I have a lot of dashboards showing charts etc. from summary fields, reports and direct from the smartsheet. I calculate a lot of summary fields based on dates - for example yesterday, this week, last week, this month, last month and tend to use helper fields of true & false with formula to calculate as this then…
-
Why is my dashboard link sending me to a sheet instead of the dashboard?
We have a startup intake sheet in Smartsheet connected to Salesforce to process all of our new business wins. Once a win comes in and I approve for a project plan in control center , a site plan is created and a dashboard link appears on the intake sheet. Up until the other day the dashboard link always took you to the…
-
COUNTIF tally meeting criteria from two dropdown columns
Hoping for some help with some formulas tally information in some of my spreadsheets. I'm tallying data totals that meet criteria in 2 separate dropdown columns in order to turn these into charts. I need to know how many audition types (commercial, radio, etc) came from different agents or databases. Example: How many…
-
count individual instances rather than totals
I need help modifying a formula that counts Request ID occurrences. My current formula counts the total number of times each Request ID appears, but I need it to count each individual instance instead. Current formula: =COUNTIF([Request ID]:[Request ID], [Request ID]@row ) What it currently does: Counts total occurrences…
-
Lock Column order but not edit rights to the content
Is it possible to lock column order such that users cannot move columns left/right, whilst retaining the ability for all users to make edits to the content of the columns as required? Problem Statement - multiple users create new columns or move columns in a n existing sheet and want to lock an agreed field order for all…
-
Count formula - If two columns equal different values
Hello, I'm trying to use a sheet summary formula to count how many times the "Status" column equals "Complete" AND the "Level" column equals "1". I've used several iterations of a formula and continue to get errors. Can someone help? This is one of the formulas I tried: =COUNTIFS({Status:Status}, CONTAINS("Complete", @cell…
-
What formula will pull client specific data from one sheet?
Hello. I am using smartsheet as a ticket tracking database for multiple clients and want to create dashboards for each client to review their individual metrics (tickets opened or closed this week, month or year etc). I can easily pull a total ticket count by day, week, month etc using the formulas below: Last year:…
-
#Circular Reference
I am trying to create a workflow where if the "Pull Date" cell is in the next 14 days, the value in the Status column changes to "Upcoming". The workflow did not work. So, Smartsheet AI suggested formula =IF([Pull Date]@row <= TODAY() + 14, "Upcoming", Status@row ). I put this formula in the Status cell and get #Circular…
-
[Need Help] Lookup/Index matching for Horizontal Data
I’m trying to automatically assign a reviewer type (like “Peer” or “Leader”) based on a reviewer’s phone number. The problem is that in my reference sheet, the 20 possible reviewers are listed across columns — each one has a phone number and a reviewer type in a separate column. In my submission sheet, I just have one…
-
Count all open items each month and keep prior month count.
I have a sheet that has a year column, month column and an open / closed column. I want to show how many open items I have in the full sheet at the end of each month. I want to keep prior month counts. I can count full month easy, but it's harder to do it by month and keep past history on my count. Thanks MONTH Open Jan 36…