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
Export sheet URLs to excel
Hi, I'm trying to export multiple secure sheet links (urls) to excel (or pull them into a report) so I can upload them to a field in Salesforce. Is there any easy way to do this? Thanks for your help!
Sort Rows A - Z messing up formulars
Hi Team, I use the top row in my sheet to calculate data in the sheet, because I cant freeze the top row when I do a "Sort Rows A - Z" it moves the formula even though I use ([$Row$1]:[$Row$50]....... I was looking at Cell linking the rows with the date I need in another sheet so the top row in the new sheet would never…
Approval not sent to self
I have an issue list with numerous people assigned tasks. I use the approval process when ever someone closes an item. The problem I have is that if the owner of that item closes it they have to go through the approval process. Is there a way I can avoid this? would comparing the modified to assigned work?
Use Dropdown column to populate an alternate column in a sheet
I am trying to populate an address in a separate column with a dropdown column that has corresponding branch numbers in the same sheet. The user enters a branch number by dropdown and I would like it to populate the address column with the corresponding address for the branch. I am using a LOOKUP formula and it works with…
Ghant Chart with quarter headings
I really like the quarterly level ghant chart. However, when the earliest task begins near the end of the quarter, I have two months of blank ghant. I thought that I could force it to show only the part of the quarter that has a task by specifying a date range. But, I still get the blank part of the quarter. Is there any…
Standard Calendar layout template?
I want to explore using Smartsheet for editorial calendars. I'm having a hard time finding any templates that display as a monthly calendar with seven day of the week columns and rows for each week. Is this something that exists in Smartsheet or should I look at another option?
How to setup a quotation number request feature?
I would like to set up a form where the users will enter the details of a given, and submit. An automatic sequential number is to be assigned to this entry and notified to the user who sent the request using the form. Is that something that can be done with smartsheet?
Card View Settings Help
How do you make adjustments to Card View Settings after you have created a field? Also how come unchecked fields still show up in my cards?
Answering community questions...
Haha For the first time in living memory i have answered more questions/ scored more points than my colleague Craig Williams and i'm told by Gwynneth that i'm going to get a badge! Made my day! PS I only managed that because I know Craig is on a long flight Pps I have left the serious formula questions for you CW! RichardR
assign child rows from parent row
I have multiple parent rows each with over 30 child rows. I would like my "Responsible Party" cell in in each child row to be populated if I assign it in the parent row. I.e. I would like to select the contact (Responsible Party)in the parent. I would then like for each child row under to automatically be assigned to the…