-
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?
-
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…
-
Calendar Syncing
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…
-
Document Control
I'm wondering if anyone has used Smartsheet to set up a Document Control process, and if you have any suggestions to how I might get started with that. I would like to have a form log that generates sequential form numbers as well as a way to keep completed forms with a single access point. Automated approvals would be…
-
Notification Email Background Color
My notification emails are now coming across with a colored background. Is there a way to turn this off in SmartSheet so that I don't have to do it when I forward my emails?
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…