-
Capturing Approval Dates
I didn't see a solution to this anywhere, but I was wondering if there is an easy way to capture the approval date and put that date in another cell. I'd like to use this as a predecessor to another task, and if the approval is late, the other dates adjust. I want approvers to easily see how their delaying approval of a…
-
Edit lock rows
Hi, Can I lock rows and assign specific people to edit it? Example only sales people can edit rows 1-10 and managers can edit rows 11-20?
-
Cross Reference Formula: No "AVEARAGEIFS" so trying to use "AVG(COLLECT(" to use multiple criteria b
I am trying to average how many days a claim has been open for a certain technician. We signify the claim being open by having a certain column being blank... here is the current formula that I have: =AVG(COLLECT({West (Tech Sheet) Range 1}, "", {West (Tech Sheet) Range 2}, "Artur Alimov - ARAL", {West (Tech Sheet) Range…
-
Dashboard Display Current Month
Hi! I've created my first dashboard to report sales data from a sheet that captures 1 year of data. My data rolls up the totals for each week, month and year, currently I have the widgets referencing the totals on the January row. Is there a way to display on the Dashboard the current months totals only and not for the…
-
Edit Column/Row Without Triggering the "Last Modified" Cell
Hi there, I`m trying to create a color code that shows the tows update status. I came up with this formula: =IF(ABS(Modified1 - TODAY()) > 30, IF(ABS(TODAY() - Modified1) > 90, "Red", "Yellow"), "Green") the formula works fine, but if I start working on a new row, I want the color code to be applied automatically, which…
-
Validate if the Hyperlinks in the cell are a valid URL's
Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200. Any help is highly appreciated. Thanks
-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
Track changes in Dashboards
Hi, Provided that I am "viewer" to a Dashboard item, any way I can track changes to the Dashboard(including the attached Sheet, attached files, attached item,etc)? Thanks. Ben
-
Image in Dashboard
I am working on a template for my dashboard that would show an image of the project in the top right corner. Now this image will change for each project. The goals is to have some of the data for the dashboard pulled from a Metric Sheet, I have added the image to a cell there and figured I could use the Metric widget to…
-
Prioritising responses
Hi SS guru's! I'm looking to create a dashboard that essentially visualises a list in priority order, based on the time we receieve a form response. So far I have a sheet where responses are logged, and we use system generated modified (date) to log the date and time we recieved the confirmation. What I want to do is…
