-
Enhancement Request: Customize "Include my changes..."
Allow customizing "Include my changes in sheet notifications" at sheet level 1. New notifications get default 2. Can be changed at sheet level 3. Existing sheets keep their choice (better: when global is changed - ask for user input) Low priority. Of all the sheets I personally use, there is a very small subset I would…
-
Meeting minutes
Anyone with experience how to manage meeting minutes in a good way using Smartsheet?
-
Is there a way to use LOOKUP to get a total qty for the reference if it's been entred multiple times
Hi, I'm really not sure if I'm going about this the right way, but I'm trying to create a 'Bill of Materials' within Smartsheet for a construction project. As per the two pics attached, I would like to get the value of a product that is mentioned multiple times in a particular column. For example, 4 of PRODUCT 2 is going…
-
Sharing Sheet- Multiple Accounts/Same Email
Hi All, This might seem like a strange question. I shared the sheet to a coworker and she created a free account, later she then went and obtained a licensed account. So now she shows up twice in our drop down of contacts and when typing in her email address to share a sheet to it shows both accounts. She misspelled her…
-
Countifs formula using or
Hello. I am trying to count the RYG ball (in this case red) for each team. One of our teams is comprised of three sub-teams, so I need for it to be counted if any of those show a red ball. How do I create or for the Team section of this formula? =COUNTIFS([Overall KPO Status]:[Overall KPO Status], "Red", Team:Team,…
-
OR formula help
I tried to modify the OR formula and combine it with a function involving RYG symbols: =IF(OR(IF(TODAY() - [Order Due Date]2 > 0, "Red"), IF(ISBLANK([Order Date]2, "Red")), IF(TODAY() - [Order Due Date]2 > -4, "Yellow", "Green"))) There are basically 3 columns: Order Date, Order Due Date, and status (RYG). I am trying to…
-
Calendar View Month has 6 weeks?
April 2017 is an aberration. It spreads across 6 calendar weeks. So is July, so maybe not so rare. Is there a way to show the entire month in Calendar View? (I doubt it) Craig
-
Creating an Actual start, Actual finish and Actual Duration columns
Creating an Actual start, Actual finish, Actual Duration columns, I have created those columns on my smartsheet for the purpose of tracking but I would like to make them default calculators for my project leaving my Start Date and End Date as baseline dates But the columns I created would not allow dates to be altered with…
-
difficult or unstable to access SmartSheet
Hello SmartSheet, Recently, my colleagues who work in Weifang China told me that it's very difficult to access to SmartSheet. The issues are: * Sometimes we can access it very well while sometimes it's impossible even to open it; * It will take us long time even hours! to open it. * We have tried different exploers, such…
-
Smartsheet Maps
Are these working for anyone? Seem to be down.
