-
Need to Count Unique Values Based on Criteria from a DropDown Collumn
Hello, I need a function that can identity duplicates and determine if they should be counted as one or more than one depending on criteria within another column of the spreadsheet that is a dropdown. The specific context is there is a Name Column (Column A) and a Dropdown Column (Column B), Column B has three options "Yes…
-
Using Dashboard to run meeting - Ideas to add in a timer?
Hello! Using a Dashboard to run our weekly meetings and had an idea to add in a timer inside the dashboard to stay aware of how much time we have left to discuss each topic. Smartsheet doesn't allow any domain that I know of that can allow me to embed a timer... So I tried a workaround. Embeded a Google Data Studio Report,…
-
Why does this formula not work today?
=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) - WEEKDAY(TODAY())) It is the Weekday part of the formula that is stopping it from running. Using INT and VALUE and whatever else I can think of doesn't work. @Genevieve P
-
DataMesh - Duplicates In Source Sheet
I have a DataMesh sequence that I run that where the source sheet can have 1 to N number of entries, and it's valid. As I understand it, DataMesh only allows me to select two options - Pick First Match and Ignore Entries. In either of those scenarios, I'm not going to get all of my entries. Is there another way around this…
-
IF formula for RYG balls
Hi I am trying to make a formula that states: If it is 14 days past the TBF date field, and the Reported date field is blank, make the ball Red. If it is 7 days past the TBF date field, and the Reported date field is blank, make the ball Yellow. If the Reported date field is NOT blank, make the ball Green. Nothing I try…
-
Not all fields are being included in the webforms confirmation email
Hello, One of my colleagues brought it to my attention that when they are completing a form and request a copy be sent to them for confirmation, one vital field is missing from the email. It is a numerical field, relating to IDs. The entire field is missing from the confirmation, including the title. I'm not seeing any…
-
Count days between start date and today
I want to count the days between the start date and today if the end date is blank.
-
Average formula
I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will happen when there is no inventory at the moment). Can someone please advise where my…
-
Feature Request: Smartsheet Desktop apps (specifically for Mac!)
Dear Smartsheet Team, PLEASE build desktop apps so that users don't have to rely on their browser to use Smartsheet. If you look at most people's browser, chances are they have a million tabs opened. That makes it easy for Smartsheet tabs to get lost in the chaos, which in turn reduces overall productivity and prevents…