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
Website form integration using API
I am attempting to use the API to add comments into a new row created by a form submission. I am currently adding new rows to sheets through forms on our website that integrate with (amung other things) the Smartsheet API. Our website utilizes C# so I am using the following code (partial) to submit to a sheet. Cell[]…
Editing Reports Without Having Access to the Underlying Sheet?
For my solution it would be very convenient to share reports with edit rights without granting them for the underlying sheet. I was not able to achieve this, however, I may as well have tried it the wrong way. Any idea? Thanks and cheers
If Status is "Completed" then make % Complete "100%"
I need help with the formula to automatically make the % Complete be 100% for any row where Status is "Completed" Do I put the formula in the % Complete cell? And if so, what formula? What I have tried so far does not work: =IF(Status=Completed,%Complete=100%) That's probably wrong for a variety of reasons, but I can't…
Web form confirmation emails with multiple fonts
Has anyone experienced web form confirmation emails displaying multiple fonts? I have a client who set up a web form and is having this issue. Some information is in Arial, some is in Times Roman. I've tried to replicate things on my end, but my confirmation emails are all Arial. I'm wondering if it has to do with the…
Comments headings
Hide columns when drop down menu it a specific item
I have a project sheet that has the tasks, actions, risks, etc. The risks have specific columns that apply to it. I want to hide these columns unless the item type is risk. I have searched for help with this but can't seem to find the solution.
SUM of consecutive cells until blank cell is reached in the column
Hi, i am trying to SUM any given number of consecutive cells in column A and need it to stop once a black cell is reached. For instance The SUM will be column A, row 2 to 6 (7 is blank) and I am wanting the SUM to display in column B row 1. This will repeat throughout the sheet, but the SUM result will always be column B…
Card view - spanning lanes
Hi Is it possible to have some fields in the card view span several lanes? Thanks, Galit
LOOKUP function return value
Hi Smartsheet team, Thanks for getting the much awaited LOOKUP function supported in Smartsheet.. This is a great add !! I see a problem with LOOKUP() return value when the lookup_value is not found in lookup_range. It is returning Empty string instead of an Error. Because of this, I am not able to distinguish between key…
Reports in SmartSheet
I want to create a report that summarizes information on my smartsheet. I don't want it to list individual line items. Is this possible? I am trying to mimic something I am doing in Excel with pivot tables and tables. If it's not possible - does anyone have recommendations for reporting plug ins?
