- 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)))"…
- Formula to split up / break down long strings of text
Hi, Hope you're all keeping well. I was hoping someone could point me in the right direction of a formula / function that can help break down large sections of text. If someone could point me in the right direction, I should be able to work out the nuances and implementation myself. I have an API that exports data into a…
- 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!
- Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
- Objectives and Key Results - OKR's
Does anyone have a template or know of an existing template that could be used for OKR's?
- Rolling Months on Pivots and KPIs
I have a question on how to update my KPI's where the data populates by month and will automatically start copying from the new month while dropping out an old month that is 13 months back? This will always show me the latest 12 months. I have multiple sites that I am running the reports from and would like to automate…
- Work Flow - Clone to another worksheet
I LOVE the work flows!!! But I have 15 facilities and 15 of the same worksheets. Is it possible to: 1. Clone the work flow from one worksheet to another or 2. print the work flow so i can enter the same verbiage & flow in all the sheets. While I am here - is it possible to send an Update Request WITH an attachment? thanks!
- 日历同步
Is the calendar sync still only a one way export? Is there anyway I can link my smartsheet calendar to Outlook and then share this with others? I have used the iCal function and this has created a new read only outlook calendar that I can not share with anyone. While calendar view is still not available on the mobile app I…
