Hyperlink support in Index/Match/Collect/etc. functions
As other posts for help point out hyperlinks do not transfer when when using functions to look up hyperlink values. Please add support for looking up hyperlink values via formula such that the Display Text and URL transfer to the destination. See details in the links below. The workaround of linking to a cell in another…
Staying informed of changes to Smartsheet software
We have a sheet and it works wonderfully. A few weeks ago, everything seemed to break. Half of the formulas were all of a sudden throwing errors. So, we changed a lookup to include the VALUE function. Got through that surprise. Today, the same thing is happening and so far it appears that the formulas can work again if we…
Data merge help.
I have a report that I pull monthly. This report has quite a bit of information, but the primary data I am hoping to manipulate is SKU numbers and SKU sales per SKU number. I have created a Data Shuttle as well as a MERGE INPUT SHEET and a MERGE RESULTS SHEET I attach the excel sheets to the INPUT sheet which then triggers…
project management certification prerequisites
Hello all, I'm wondering if I need to complete the core product certification prerequisite before taking the project management certification exam?
COUNTIF & WEEK
Hi All, A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm. I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would…
Problem moving rows within a sheet
Hello. I am experiencing problems with a simple select and move of any row within a sheet. In the screenshot below I have highlighted row 2002 and am looking to drag it down to between 2006 and 2007. However it ends up being placed between 2003 & 2004 (where you can see a faint blue shading). This is really annoying as I…
Hi, I had a formula working this morning, then i made some changes in other columns and now i'm getting the error invalid operation and i dont understand why as the formula still looks correct, however its no longer working. Hoping for some suggestions as to why please. :) Thank you!
Merged: Adding groups to preferred contacts in "contact list coloumn"
This discussion has been merged.
Please enhance Column Contacts and Form Contacts by allowing Groups to be used!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
How to create a request order form for multiple items/quantities
Hello Smartsheet Community, The basic order form from the "Workforce PPE Inventory Tracking" template set only allows one item and quantity entry per row per and per request tracking number. Is it possible to add/associate multiple items and quantities in multiple rows to one request tracking number? The basic order form…