-
Date format is wrong
Hi Expert, I did a data upload via data shuffle from an excel file including the following English dates e.g. Dec 1., Feb 1, April But in Smartsheet it looks like this: So it switch the month with the day. My settings are english in smartsheet as well. How can I fix it? Thanks
-
One group of writers always assigned to same editor by automation?
I'm new to SmartSheet, however, I have basic knowledge of its working. I am trying to assign a number of writers to the same editor for approval of content (articles) by automation? Is this possible with SmartSheet? For example, I have 20 writers and 2 editors. I want to have a Group A where there are 10 writers and 1…
-
Need way to add a counter on a dashboard for user "views" or visits
Hi everyone. Absolute beginner here. I'm tasked to make a few dashboards for other internal company teams on project progress, etc. We want to track how often people visit each dashboard and thought it might be useful to include that as a counter widget on the dashboards. Mockup example below. Doable??
-
Smartsheet group access
Hi team, I have create multiple users group in Smartsheet. could you please confirm that who other than me can change that group, if I share the user's owner or admin access to the project.
-
OVERFLOW BECAUSE of CHARACTER LENGTH
Hi I'm having an error because of the character length of my "Account Number" that will be the basis need to get the highest/latest "Service End Date" every row. Here's my formula: =MAX(COLLECT([Service End Date]:[Service End Date], [Account Number]:[Account Number], [Account Number]@row))
-
How do I remove a zero from a cell when using the COUNTM function?
I have columns that use COUNTM. Some of the results come back with 0 as the value. I want to leave the cell blank in this case =COUNTM([Member Email Campaign Opt-In]@row) I suspect I need to include an "IF" statement where "0", ""
-
Specialized Report
I have a report that goes out weekly that looks like this: As you can see it shows in one small area, reservations, contracts, cans, closings and traffic for the week, month, quarter, year and for the entire project. I'd like to find a way to do this same report in SS. Here is my source sheet that is input via a form and…
-
Not a Question, a statement.
I love Smartsheet. No, I really, really love Smartsheet. It made it possible to run large projects spanning multiple sites without me and my team chasing info. I should get the bumper sticker, been looking for it but not in Africa, bummer. Ditched MS Project back in 2012 and never looked back. I believed in the promise of…
-
How to I solve an #OVERFLOW and blank formula?
I have a problem with some formulas that I am using, they are: =MAX(COLLECT([Service End Date]:[Service End Date], [Account Number]:[Account Number], [Account Number]@row)) This one helps me find the most recent bill date for an specific account. =IF([Most Recent Bill Date]@row = [Service End Date]@row, true, false) This…
-
Charting with dates using the data on the Report Item
The labels for my date are weird. How do I fix? The information under each Due dates are file names.
