-
Can sheet EDITOR make sheet "invisible" for a period of time?
I have a sheet for which I'm the owner and I've shared it with 10 people in a workspace. I have one collaborator whose permission level is "Editor -- can share" and I'd like that person to be able to temporarily "check out" or make the sheet invisible to other users while she's making her changes/additions. I know that the…
-
Cell Change Counting
Hello, Is there a formula that will count the number of times a cell changes? Thanks, Rozan
-
Time Formula
Hi there, I need a formula that will round UP time, for example if I have 2.5 hours worked I would need the column to round up to 3 hours. I have an hours worked column - 2.5, and a column of time paid (which needs to round up to the next hour, in this case again it would be 3). Thanks, Melissa K
-
add [date](summary of projected days to [Number of days]
add [date](summary of projected days to [Number of days] Is there a simple formula to this . =[Site Walk Schedule Date]1+[Projection Totals days]6 =11/1120177.777 its adding the the date as a number instead of date 11/11/17 to 6
-
RSS Feed
Hi All, I have a question regarding RSS feeds. Currently, I am utilizing Zapier to have a Google News RSS feed add new rows to a sheet. Then I generate a report so that I can have widget in Sights with news from the past few days. I've found that there could be hundreds of news articles a week, which will use up the 5000…
-
dependent actions
Can actions be made to be dependent upon another action? For example - Can I trigger an action to occur when a specific button is pushed and have the action affect a specific field in the same row as the button ? - specifically , I am wondering if I can populate a field with the current date (say field 3) when the button…
-
User with Admin Permission not able to edit Sight?
Hello! I've created and shared a Sight with an end user and have provided Admin permission, however they are not able to save any of their changes when they try to edit the sight. The error message says "You do not have sufficient permissions on this Sight to make this change." Thanks, Nick
-
Report - Imported sheets are shown but new Project Sheet does not
Hello, The majority of the time we import an MS Project schedule and have had no problems with pulling those into a report. However, if we create a new blank Project Sheet and enter the tasks through the web interface, those sheets do no get pulled into the report. The columns for the Start & End dates are different…
-
Monthly Management of Projects
Hello All, I am now responsible for reporting on the progress of multiple projects in our organisation and what is going on. I have created Sights for each that roll up into an overall position to save time and effort. However, I would like to create a task list for myself to make sure that i have covered all bases on…
-
Prefill Webform with QR Code
Hi all! I've been playing around with webforms and data stored in QR codes for my company. What I've got is when I scan a QR code, it sends me to a Jotform survey that pre-fills fields from the QR code into the form fields. For example, the data stored in my QR code looks like…
