-
Getting Oldest Date based on another field
I have created a Metrics Sheet to roll up the oldest date based on another field. I am trying to have it return the oldest date in the "Date Sent to CSOS" column if the Date approved by CSOS column is blank. I can also use the if CSOS Review column is Submitted but I can't get either one to work properly. Does anyone haveโฆ
-
Is there a way to set up Cumulative Roll Up Notification Emails
We have a large team all working within a workspace, and they already get a TON of email. Is there a way to set up a single daily notification for new items assigned to team members, without it being an email for each sheet? We have about 10 sheets that are being used, so would prefer not to see users getting 10 emails.โฆ
-
What is wrong with this formula?
Hi, Could one of you please tell me what is wrong with this formula: =IF([% Complete]@row = 100%, "Blue", IF([End Date]@row <= TODAY, "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green"))) I keep getting an #UNPARSEABLE error.
-
Date Formula for the First of Every Month
Is their Formula I can apply for the Date to be the First of Every Month, because not all months have 30 days. Some have 31, like July? For example: 04/01/20 05/01/20 06/01/20 07/01/20 My current Formula which does not work for the Month of July =Date3 + 30 Thanks
-
Finding duplicates and checcking blank cells
Hi there, I am at my wits end and I think it is a very easy solution, however I cant see it. I have a column of project numbers, and I am trying to see if there are any duplicates, as well as if the project number cell is black, to leave it blank. What I have done is sort the project number column in ascending order and inโฆ
-
Loan Amortization Formula
Good Day All: I need some help with my Loan Amortization Formula. I am trying to subtract out the Escrow from the Principal that is included in my payment. Current Formula Yields $1,771.06 which is incorrect. The correct amount is $322.85 if he Escrow is $1,448.21 per month =IF(Interest7 = "", "", Payment7 - Interest7 +โฆ
-
Forms - Workflow to track submission
Hi, Is it possible to populate an existing row using forms? The idea is we have two existing columns (Customer and Due date)and the rest are from the form. If no reply has been made past the due date, a workflow would automatically send an email to the recipient reminding to complete the form. The problem is, formโฆ
-
Pulling from another sheet based on conditions
Hello everyone and thanks for any help you might be able to provide me, with my project. What I am trying to do is update a single sheet and have as much of that information populate another sheet as I can, but only if the customer is a certain one AND the "SFDC Category" = "Closed Won". Here is what the first part of myโฆ
-
Check a task done from a report on a dashboard
It could be I misremembering --- I have a report that lists all the users tasks and the tasks are accompanied by a Done checkbox. Is there a way to allow users to check that box _from the widget on the dashboard_ rather than having to open the report or the source sheet. Is this possible or a fever dream?
-
Removing old entries by comparing Modified time
Hello, I am trying to find the index number of a matching number in column7. So if Column7 was 56 I would expect that this function =MATCH([Column7]1, (COLLECT([Column7]:[Column7], [Row ID]:[Row ID], <>[Row ID]1))) would return 4. Collect returns a list of numbers which are not blanks and excludes itself since it isโฆ