-
Updating multiple sheets and having recent updates report to a rollup sheet.
I am trying to get multiple sheets to report updates to a rollup sheet or report. I was wondering if anyone out there knew how to do this or if there was a formula that will help on this issue. Thanks, JC
-
Large doc with rows of data - dates
I have a sheet that we use to co-ordinate service work. It is getting pretty big. Is there anyway to have Smartsheet automatically go to todays date on the sheet, as opposed to starting at row 1?
-
Trouble importing large excel file
I am trying to import a large file. It is under the 10MB limit, however it has 44k rows, and the standard import excel function only allows for 5k rows. Copying is limited to 500 lines. Is there any way to import such a large file, or can new imports be appended to existing smartsheets? Thanks, Adrienn
-
Custom View on Grid/Gantt
Often when I setout a new schedule layout I end up with a number of columns either auto- calculating, which I subsequently hide, or tracking finance, progress, comments etc and the view is busy... I'd love to be able to Save custom views, so I can select chosen columns to view. IE. Custom View 1 - Finance. Shows me the…
-
Can I reorder card fields?
I love the new Card view, and am easily creating new fields and showing/hiding from view. But I can't see a way of reordering the fields on my card? I've tried reordering the columns in Grid view, but doesn't seem to reflect on the card. Am I missing something?
-
Allowing for unresourced time requirements
I'm evaluating using SmartSheet for project managing construction projects. So far, so good. One of the requirements is to allocate time for processes such as plaster drying out. So no resource is required, just a number of calendar days, which can include weekends/holidays. I can set up a "task" for this with dependency…
-
Managing Resources by duration and not % allocation
Is there a way to manage resources by time rather than having to use % allocation please? Any way aound this? Its actually not that easy to manage using a %. Sad that smartsheet didn't think it would be an important feature. I'm no software expert, but seems like not too difficult a fix if they already implemented it for…
-
Potential New Feature - Important batches of images row after row in a column
I was importanting some images via dropbox one at a time and thought it would be useful it would be to import multiple at a time per row. Smartsheet as it stands today is pretty damn good, I have switched over my todo list from evernote to SmartSheet but just wanted to share more simple ways ( from the outside looking in )…
-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
Sending a row-with hightlights?
Hello, When I send a row to someone in my contacts, I want the information that was been recently changed to be highlighted (to alert the person of the changed cells when the sheet is quite large). Is there a way to do this? I have the "Highlight Changes" on, but it does not show up in what is emailed. Thanks for any…