-
Request for New Feature - Zoom - to speed navigation
I’m simply looking to navigate around the projects I currently have, as quickly as possible, to focus on the issues I would like to address with my staff. The challenge with the reports feature is it completely removes the indenting/nesting of rows, which as a result only causes more confusion. I would like to ask if…
-
All-in-one-place form for collaborators via Update Request?
In using Update Requests, is it possible (or HOW) to include the discussion thread, comments or a link to all that? And how can I include the connected documents, or a link to them? CONTEXT of question: When assigning tasks to collaborators with no spartsheet experience, I want to give them the chance to update the status…
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
Adding to dropdown list
I have a dropdown list created, and I have it set to not restrict to the dropdown list only. I would like to know how to easily add values to the dropdown list without having to go into the column properties. Logically I would think if I type in a value in the cell it will add to the dropdown list, but it doesn't work that…
-
Nesting MIN and IF functions
Hi, guys! I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I would like to calculate the due date of the next report which has not already been submitted. To find the…
-
One Time Links for Update Requests
Is there a way around the ONE TIME Link, WE NEED THE UPDATE REQUEST LINK to stay active and allow more than one entry. This will allow the user to add notes / comments as they try to achieve the update and obtain the information
-
Approval Process - Ignoring Requests
Hello, I feel like I should know this (or be able to find it elsewhere in the community), but I cannot find the answer I need. (See screenshot) Basically, we have an approval process set up that works perfectly. As soon as HR submits a document, it is forwarded to Executive Approval. Once approved, it then auto-sends the…
-
Update Requests from Mobile
Why can't I send an Update Request from a row in the mobile app? I tap the row to open it to edit and I'm not able to send an Update Request. I'm on an iPhone, if that is important.
-
Daily Notification
Hi All, Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date, Red is overdue). What I would like to do is once the dot turns Red, to have a…
-
Update Requests 'Today'
Hi, I have a planned date column, and I would like to send out an update request to the contact column when the planned date is = to today. Is this possible? Thanks, Aaron