-
Building Asset Manager Template
Hello Community Would anyone have developed a Building Asset Management Template from the one in Templates. Inparticular regarding ongoing maitenance and periodic safety inspections? If not, I would be pleased to share when I develope one. Thanks in anticipation
-
Planing a load of production
Hello I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees. I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell. =IF(ISERROR(PRORATE($[Total hours]32, $Start32,…
-
Error appeared on sights
Hi, could you pls help me on the error appeared https://www.dropbox.com/s/n2151kjdm0dwpn1/Screenshot 2017-02-01 11.05.42.png?dl=0
-
JIRA Integration: converting JIRA estimates into Smartsheet duration
Hi Smartsheet Community, We've integrated JIRA into Smartsheet. Our goal is to use Smartsheet to view the high-level roadmap of a project, based on summing the estimates of all tickets in JIRA. In JIRA, our tickets are estimated in hours. When the workflow is synced via the "Original Time Estimate" field, they somehow…
-
Multiple Duration Columns
Hello. I'm a new Smartsheet user. I used the "built-in" duration column to calculate the number of workdays between the Planned Start Date and Planned End Date. I also need to calculate the number of workdays between Actual Start Date and Actual End Date. What is the correct formula? (It would be great if Duration were a…
-
Filtering Alerts for Status
I have standard project action logs set up with alerts sent to task owners two days prior to a specified due date (date type column). There is also a status column indicating if the action is OPEN or CLOSED (dropdown type column). It would be very useful if the alerts allowed a filter to be applied so that, in this case,…
-
JIRA Integration: automatically clear completed issues?
Hi Smartsheet Community, We recently integrated JIRA to Smartsheet and are trying to limit the information that flows into Smartsheet. Our goal is to plan the roadmap based on all incomplete tickets (Issues) in the backlog. This means that we don't want to see completed/resolved/done tickets in Smartsheet. The way we set…
-
Feature Request: Kick users off of sheets (using command or timer)
OK, so I'm working to fix the sheet for my team in China while they are all at home sleeping soundly. Problem is that over half their team is still logged into SS and viewing the sheet I want to fix. If their autosave features are set incorrectly, or they make the simple human error of treating this thing like an offline…
-
Scroll wheel not working with system settings
I swear I posted this somewhere else, but cannot find it now. Opening a new post. I am able to scroll, but I find that Smartsheet does not respect the settings of the mouse scroll wheel while I am in a sheet or report. If I go to the home tab, or scroll around in my favorites, I can see that one click of the wheel ~= the…
-
Reports and master sheet relationship
Hello, If the reports are linked to the master sheet and any changes to the master sheet will automatically update and show on reports derived from the master, is it also true the other way? In other words, if I delete or add data in a report, will it also reflect on the master sheet? Thank you in advance.
