-
Filter default
Is there a way to save a filter as the default. I want the same filter applied every time the sheet is opened without the need to select it.
-
Creating a Daily Total Sheet from another Sheet that Updates Daily
Hi all, I am having trouble finding the best practice for this and thought it might be easier to ask here. I have my "Main Data" sheet that gets replaced daily through a Data Shuttle workflow. I need to create a helper sheet that totals the count of one of the columns and keeps track of the totals for each day. For…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Counting Cells that contain text
Good Afternoon, I'm trying to add columns that only contain text. I have a column where the users insert "issues" that they have with that particular line item. At the bottom of the sheet, I need to have a running total of how many issues are listed (and then make a graph) so I am trying to make a formula counting blank…
-
Please bring back the tabs...
The new December 2018 look prevents easy navigation and inhibits work-flow. This is not a positive update. I see numerous posts expressing the same opinion. Please bring the tabs back or make them an option.
-
Pivot App Zero Values
Hi All, I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushing the data in these fields as number summary in the Dashboards/Portals. Other than creating new…
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
Inspection Records
Hello I want to produce a record for equipment inspections. There will be over 100 items of equipment to list and inspection frequencies vary. I will need to show evidence that the inspection has been carried out, by whom and on what date. Ideally, it would be good to be able to show basic points checked (guards, cables,…
-
Can I hide predecessor lines in a gantt chart?
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but the predecessor lines? Thanks!
-
Objectives and Key Results - OKR's
Does anyone have a template or know of an existing template that could be used for OKR's?
