-
How to count a field which has a certain character in it.
I have a field with the date formatted as 09/30/2024. I would like to summarize that field with the count of lines containing 09 and 2024 (so basically by the month and year). I am attempting just for the month and can not get it to work. =COUNTIFS([Next Renewal Date]:[Next Renewal Date], CONTAINS("09") But I would also…
-
Customer migration notification in Plan & Billing is available!
We are excited to announce a new notification on our Plan & Billing page, designed to inform credit card and ACH direct debit customers about the transition to the User Subscription Model. This change ensures clarity and transparency regarding plan rates and renewals. Eligibility: Pro and Business plans in Commercial US…
-
Dashboard can't be publish
When I want to publish my dashboard, it always show me an error message. The situation continue few days. How can I resolve it ? thanks.
-
Rolling 12 Months and Rolling 4 Quarters Formulas for Dashboard Charts
Hello, I have a metrics sheet that has static start and end dates for each month of 2023 and 2024. The requirements changed for the dashboard and management wants the dashboard charts to show data for a rolling 12 months and a rolling 4 quarters. This screenshot shows the column setup and formula I have for calculating the…
-
How to run reports involving a percentage of different dropdown options
hey all - I just started using Smartsheet to keep track of our company's sales quotes/conversions ETC. I'm trying to build a report that reflects the total $ and number of quotes by a responsible teammate and reflects a % of converted quotes to track our ability to accurately and quote timely. I'm running into an issue…
-
Replacing all special characters in form query string parameters with a formula
Hello everyone! I am excited to be speaking at the "Leveraging the Query String in Forms" session at Engage 23! I wanted to share a formula that a customer and I developed to replace any special characters that could show up in cell when you are building a URL to a form with query string parameters using a formula. This…
-
Dynamic View Logic should behave like Conditional Form Logic (aka "live")
Logic in Dynamic Views should work as it does in Forms - changes / info entered while filling out the form results in changes to the form based on established logic. Instead, DV Logic is applied only when a request is loaded or saved. This is a follow-up to an old discussion on Dynamic View logic behavior (here) PAIN…
-
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
-
Report filter column color symbol count each color put on dashboard or the reprot
Hello I am a basic user. trying to add count of each color to dashboard or report. from my report I use in my dashboard. I attached a sample of what I want and what I have. Thank you in advance. What I have What I want
-
Time Being Added to a Date and Day Concatenation
Hi, I am setting up a scheduling report for my Team and would like to group each task in the report by a column that is a concatenation of the task start date with the day of the week for that date (e.g., 12/20/24 - Friday). When I create this concatenation using the formula below it works, but also adds a time of day into…
