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 2017 Posts
Archives for January 2017
Discussion List
Sharing charts with other users
I utilize charts on a number of sights that I have created for our leadership and each month I take a screen shot of the chart to include it as an image in the sight with a link if they want to see the real time chart. My question/request is that there be a way to share the charts in smart sheet labs with other users so…
Removing Answer Choices from Webform
I am making webform for event sponsorships. I would like the sponsors to select which events they want to sponsor - but each event can only have one sponsor. Is there a way to have a dropdown menu that eliminates choices once someone else has selected them? For instance, if I have sponsor event A, event b and event c, then…
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
JIRA Integration: automatically clear completed issues?
Hi Smartsheet Community, We recently integrated JIRA to Smartsheet and are trying to limit the information that flows into Smartsheet. Our goal is to plan the roadmap based on all incomplete tickets (Issues) in the backlog. This means that we don't want to see completed/resolved/done tickets in Smartsheet. The way we set…
Question: Formula results in reports
Hi! We use formulas in sheets. When will the calculation be done? Ony when having a sheet open? Or also when using the column in a report? In other words: If the formular uses TODAY or s.th. like that, the result differs from day to day. But is the result okay, when the sheet hasn´t been opened for a few days, but used in…
Sorting reports - line number
Hi, please enable the original line number as an available sorting criterium in reports. Helpful e.g. when sorting by (1) sheet name and (2) original sorting order within the sheet. Thank you
Formula Help please
Hi, I need a formula that will do the following please... In the field "How Many" they will select from a drop down list 1-200 201-400 401-600 >600 I will run the formula in the Cleaning Fee column. Depending on which one they select, I need values to go into the Cleaning Fee column So for 1-200 the value would be 150.00…
Keep indent on the reports (and on sights)
Hi there, I'm struggling to keep indents to materialize parents/child rows in reports. Below is the formatting in the sheet with the indent to materialize relationship parent/CHilf Is there any way to achieve that so I can keep the visibility on the parent/children in the Gantt displayed in my sights ?
Input Mask - incl. Webforms
Little surprised I've not found a similar post about this, unless I'm using the wrong terminology. Is there a way to enforce a specific input mask - say I wanted to caputre phone numbers - I want them to appear as +44 000x-0000000x (where 0 is expected numeric and x is optional numeric) - standard database/data integrity…
Adjusting Lane Width & Card Height in Card View
Hello! Is it possible to adjust the width of the lanes or the card "height" in Card View? I am currently working w/ 4 lanes and would love to adjust the width of each lane, thus allowing more detail to be shown. The ability to adjust the "height" of each card would be helpful as well...thanks!
