Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for August 2016
Discussion List
Date-based formulas now broken across 100+ sheets
As a result of the latest release and supposed "formula enhancements", we now have more than 100 client-facing project sheets whose "status" column is entirely broken. Previously our status column looked at the task Start Date, End Date, and Target Date, and intelligently spit out a text value such asย Due Soon, Inโฆ
Use linked cells as part of a formula
I'm trying to port across a large database from Excel into Smartsheet to enable us to use the Kanban type activity flow. My excel sheet uses multiple tabs, and on one of these tabs I have an 'Analysis' section that pulls in data from all of these tabs and uses cell references from multiple tabs. Smartsheet (not using tabs)โฆ
New Comment Format Causing Confusion
We have been using the old Discussions feature for the last 3+ years as a way of entering unrelated notes on projects rather than as a way to send messages back and forth between users. The recent transition to Comments has made all our notes look like replies to previous notes when in fact they are totally unrelated. Toโฆ
Primary Column Not Shown In New Comments Digest
After the new update, the Primary Column isn't shown in the daily digest of comments. It just shows the Row Number. (We have the store name as the Primary Column, so all comments get listed, but only the row number designates which comments go with which stores.) (Example below) Smartsheet Team - Can we get the Primaryโฆ
History functionality request
While you are updating the history functionality please consider the option to see updates by a specific user. I would also like to be able to lock individual cells so they cannot be updated not just columns. thanks Bill
Function 'WORKDAY' returning #INVALID COLUMN VALUE when formula in different column
Hi, I seem to be having difficulty with something that should be so simple. I have two columns 'Date Required' and 'Decision Date'. 'Date Required' is a user input date field, 'Decision Required' is (or should be), an auto-calculated field to subtract 5 working days from the 'Date Required' field. The formula I haveโฆ
Hyperlinks
Help! I have added hyperlinks to my master register but when I look at the report for those projects the hyperlink isnt showing to the sheet. Is this a bug?
Multiple discussion for one row - MISSING
Hi, Since the last update it is not possible to make more than one discussion per line. Please make this undone. I'am really unhappy! Best regards
How to autopopulate a column with formulas such that when a new line is inserted, it is automaticall
How to autopopulate a column with formulas such that when a new line is inserted, it is automatically filled in and calcuated?
Can I limit a users view to rows assigned to them only?
We want to share our sheet with multiple contrqactores but only allow them to see rows assigned to them.