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
Linking cells from multiple sheets to a report
Let me describe what we're doing: We are an agency that has several creative agents working on projects for our clients. Each creative logs hours worked on projects. We need to be able to count the total hours worked by all agents, then report that to the client report in one cell. Does that make sense? So if we have 5ā¦
Difference in Days between Projected & Actual Start Dates/ End Dates?
My managers want a column that calculates number of work days (Mon. - Fri) between Projected Start Date and Actual Start Date. Example: Projected Start Date (in Column A): 09/01/16. Actual Start Date (in Column C): 09/09/16. Difference in Days between projected and actual start dates (Column B) : 6 Days. What formula wouldā¦
How do I reset a webforms entry count?
I built a new webform and during testing I generated a few test rows into the underlying spreadsheet. I am able to delete these test rows but how do I reset the entry count that appears when the form is opened from the sheet. Setting it back to zero would be ok. Thanks for any guidance that you can provide.
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sightsā¦
Question about the link from cell in other link
I want to make a link : There is one main sheet and a minor sheet. I want to link from the main sheet to the minor sheet. But if I add one column or row in the main sheet, the minor sheet will not update the new column or row? How to make tihs???
Different columns with the same name ?
How can i make several columns with one same name???
How to merge cells?
Is it rellay cannot merge cells in smart sheet???
Where is the button of merge cells? Can we make some columns the same name?
Thanks for developing this app. This is a good point. But I think we need some necessary function like excel. such as merge cells ... And i find that i cannot name more than one columns with the same name? When I try to import excel sheet, there even a limitation. I have to split my worksheet? Takk
Card View Feature Request: "+Add Card" link at top of columns
If you have a list of cards in a column is too long to fit on the screen, you need to scroll down to hit the "+Add Card" link at the botton of the column. It would be great to have quick access to this without needing to go to the end of the list, could a link or button be added at the top?
How do I automate and validate data from one column to another
For example, have a list of cost centres in one column using a drop down list, now I want the managers name for that cost centre to populate in next column. In excel i would just use a lookup or match/index to validate and populate. Cannot work out how to do it in smartsheet.