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
Primary Rows
How do I create a new primary row in SS? One that carries sub heads and rolls up to the calendar?
Can a cell be linked to multiple rows simultaneously?
Hi, I want to link a cell value to multiple rows of another sheet. I tried copying the source cell, highlighting multiple cells in another sheet and tried Paste special - Link to copied cell. However it only assigns the value and links to the first cell alone !! Any help or direction is highly appreciated.
Help with Status and Date Columns
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status…
SUM cells in a row
I am trying to add values within cells in a child row that contain links to other sheets ... getting Total: 0 ... tried the below formula with no success ... any help would be soooo appreciated! ="Total: " + SUM(CHILDREN(Name2, Name17)
Freeze Panes
Can you freeze panes horizontally like in excel
When a task is complete ahead of schedule the dependent tasks start date is not brought forward
Hello i have tasks a,b,c - all tasks are 2 days in duration task 'b' is dependent on 'a', and task 'c' id dependent on 'b' task 'a' was scheduled to start on 1/1/16, but it was started earlier and so it was marked complete on 31/12 how do i set it up so that task 'b' now slides along to 31/12 showing it is available to…
Sheet scalability
I have a sheet that I built for year-end performance reviews. The sheet is designed for one person. My company has 50+ employees and it would be great if I can run some sort of macro/app that would take the sheet and replicate it 50 times with each sheet adding a new name from a contact list. Any ideas? Thanks Ian
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
Quote Sheet
Im trying to develop a sheet for a Quote Estimate to Customer with customer details auto added from contact sheet?
Count number of cells containing specific text
Hi, I need to count the number of cells that contains a part of a text. Is there any wildcart symbol I could use? for example abcd abfd abpd jged In this case I need a formule that count the cells with the text starting with the letters ab. /Michelangelo
