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.
Discussion List
Mirroring sheets from different workspaces
Hi all, I was wondering if anyone felt the need before me to establish some kind of a link between different sheets. So if I was to "mirror" a sheet into an other one, is there a way to populate one sheet's cells by directly linking the other one's values into them? Thanks Bálint
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.
Conditional Formatting at Sheet Level - not row/column specific
Hi there knowers of knowledge, Is there a way to set conditional formatting so that across the sheet if the condition is met the format is applied. Think: if sheet contains 'YES' apply this format, across the entire sheet. Thanks!
Release 2016-08-06 Formula Argument Declaration confusion
The release notes says: Formula Argument Declaration Calculations can now run faster with the new logic for identifying a range. Rather than using =if(a1:a3) to specify a range in your formula, your functions will need to identify each cell, =if(a1, a2, a3), separately to be able to run the argument. Using the IF()…
Release 2016-08-06 MATCH function
The MATCH function accepts multi-dimensional ranges. I believe that EXCEL does not, but can not confirm. This example returns "9". If the range is three columns, match returns 7. Is there some intended usage of a 2-dimensional search that would be useful? I see the array is processed as row major. Knowing the size of the…
Sights Sheet Data Widget updating question
I am looking for a way within the Sights, Sheet Data widget to update the selected cells as rows are added to the source sheet. Do we know of a way to accomplish this? Any suggestions would be appreciated. Thanks, Bill
API Report restricted to first page
We wish to download through url access a report that is 850 rows so expands over 2 pages. When we access it we only get the first page. Is there a way to get all pages? Below is our curl code (the XXXXX.... is our authorization which we have masked):…
Ballon Help for Formulas
I use formulas to calculate totals at the parent level in my smartsheets. When I do this, a greyed out popup comes up every time I click on the cell. While not a huge deal for non-primary columns, it is a HUGE irrittation on the primary column. It basically gets in the way of everything and you cannot access the + button…
Adding additional attachments
Is it possible to add more than one file attachment in a Webform? What would be great, is when you right clicked to edit column properties, attach file was an option. It would also be neat if you could select more than one property. Another feature in Webforms would be to add conditional formating. Thanks!
Conditional Formatting Changed Over This Weekend
I've got a development backlog I keep in Smartsheet. Many of my checkbox columns have conditional formatting - red when not checked - normal when checked. I have header rows that I inserted a period "." into and changed the font color to match the row to hid the conditional formatting. Now, the conditional formatting is…
