-
Delete all comments and data of a sheet
Hi, how can I delete all comments for all rows in one go for a sheet? Thanks
-
SUMIF referencing cells across sheets?
Since reports do not have the capability of summing the content of columns or rows I need to come up with a workaround. For several years I have been doing exactly this in Excel so I want to duplicate in Smartsheet. In Excel I have created a table that is a list of employees in the rows and a list of dates in the columns.…
-
Automated Reminders
I have a sheet with tasks per row aligned to specific team members. Each row now has a reminder which is aligned with the due date column. Once the team member updates the row with a new due date, there is no new reminder set for the new due date. Can this be done automatically, so that when there's an update entered and…
-
Maintaining Formulas When Sorting a Sheet
Hi, Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was moved to. My formula is a COUNTIFS and I want it to count what I am asking regardless of where in the sheet the row where…
-
Linking colums from one sheet to another issue
Good morning, I am trying to set up a master document with linked cells across three different sheets. First being an order form, second being a shipping form and third being an install form. All the information will link back to my system ID of which system is being installed. My question is when I highlight my cells I am…
-
Using the Project Management Dashboard Template
Hi all, I'm a newbie to Smartsheet and am evaluating its use within our organization and so far I like what I see. As a PM one of my tasks to do project status reporting and so I had a look at the Project Management Dashboard Template, this is a good basis for what I want to do. However, if I update the task dates in the…
-
Hiding Rows
Kinda new to this program and confounded on how to hide rows! I am stunned this program, in 2017, doesn't have an easy solution to this common feature of other spreadsheets.
-
Exporting/Backing up Smartsheets with Attachments that are Linked to the Rows they were Attached to
Hi, When I do backup of my Smartsheets, all of my files that were attached to any rows are saved to a separate folder. That's fine, but my problem is, I don't know which rows those files were attached to. I need to find a way of linking files to the original rows that the files were attached to. Is there a way to backup my…
-
Update Picklist via API
Hello, It don't see the API hook to update a Picklist. I would like to keep a set of shets and snc and thought this would be the easiest way. I thought it would be with the columns: https://smartsheet-platform.github.io/api-docs/?javascript#columns If it is not there yet, could I request that enhancement? Thanks, Brett
-
Using reports to create Totals
Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to enter forecasting for delivery for a particular customer in a given month. I would however like to be able to create a…
