-
Restore an "All" Where? functionality
It would be generous to call this an enhancement request. While I applaud the improvements to the Reporting (they are noticeable and appreciated), the inability to have an "ALL" for the Where? is a severe loss of functionality. I have many sheets and workspaces shared to me. They do not all exists at the time of Workspace…
-
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…
-
How to get notifications when a new entry is added via a web form
I have a web form which users use to create a new line item that requires approval once added. An automatic notification must go out to the person that needs to approve. Thereafter a notification must go out to another user to inform them of the approval. How do I set up the notifications when a new line item is added via…
-
Daily Production Planning Process
Hi All, I am new to Smartsheet. I need some assistance on exploring how it is possible to do what I need to do using Smartsheet. Idea: I want to implement a agile methodology like SCRUM and use smartsheet to manage the planning. On daily basis, people executing the work needs to select what they complete in next 24 hours…
-
RAG Formulas
I have a project sheet and I have used formulas to create metrics. I have a RAG column and want to simply create four metrics: I am struggling to find the correct formula to simply count the following: * RAG Status Green * RAG Status Blue * RAG Status Amber * RAG Status Red Many Thanks
-
Enhancement Request: Allow filter on "special" columns
Initially, I'd like to be able to filter a sheet on: Attachment (yes/no) Discussions (yes/no) Info (each of the possibilities) After that, I'd like to be able to further refine the Discussions (date, author, content) With these in place, I'd like the same functionality with Reports (show all rows with attachments, for…
-
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…
-
SUMIFS() FUNCTION with more than 5 CRITERION
Dear Everyone, How to use sumifs() function with more than 5 criterion range. It returns zero (0) even it is already satisfied with the data given for each column. =SUMIFS($Qty:$Qty, $Road:$Road, [Look Roads]1, $[Cabinet No.]:$[Cabinet No.], [LkCabinet No.]1, $[H. H. No.]:$[H. H. No.], [LkH.H.No.]1, $[Line Type]:$[Line…
-
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…
-
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…
