-
Automatic Update Request Based on Last Updated
I am looking to send out an automatic update request based on a system generated LAST UPDATED column if last updated was 10 days ago. The problem is, this function doesn't appear to be available in the alerts and actions and if i set up a reminder column, when the reminder triggers a check box or date, it updates the…
-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
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.