Hello All, Having difficulty getting my formula to work properly when a column's value is "0". If the value is >0 it works fine. The formula is supposed to follow the WORKDAY variable and exclude weekends, which it does unless the value in the [Days to add] column is 0 at which point it seems to ignore the workday rule.…
Hi, I looked at the past discussion but didn't find the answer. My sheet has a row for each events happening with the precise dates (ex: 8-Aug-2024). I would like to count any event that happened within a time frame (march 1rst to march 31rst of the next year). I tried various formulas but no luck at all…
Has anyone else noticed this week the calendar option in workflows had changed from a Sunday through Saturday format to a Monday through Sunday format? I had a workflow that sent out a notification which is scheduled to send out the end of the month on day 25 - 29, today is 8/8/24!! Upon checking to see why it ran I…
I need help coming up with a formula that enters the date in the date column any time an entry is made/ new line created. I tried the =(today) as a column formula, but every day it just updates all of the dates to be whatever day it is, and not the date that the row was created.
I have a basic project tracker that has a due date column. I'm wondering if it's possible to also include a specific time to the field?
I have a cross-sheet formula that adds the published date to my row. Once all the criteria are meet the row is then a workflow moves that row to the archive. But it doesn't seem to retain the Date designation once it has been moved. I was having issues with a countifs formula that was looking into the archives for items…
Hi! I use the below forumla to count days between to columns that have dates. The issue is it is counting the as individual days which basicall adds a day to the count. I want a true count. Help? Dtes calculated 6/7/24 to 6/8/24 (to me this is one day) the formula gives me 2 =NETDAYS([Created Date]@row, [Date Backup Sent…
I'm trying to pull the quarter & year from a column using a formula, but I keep getting "unparseable". I've searched through the community with no success using the answers found. I'm pulling data from my "Expected Close Date" column. Below is an example of a formula used. Any help is greatly appreciated.…
Add the ability to alter the End Date of a task in the edit panel within the new Timeline View. Currently, we see the message, "Formula fields can't be edited in this panel" for our end date. However, in our course, the End Date isn't a formula field. Below is a screen cap from the timeline panel. (we call our end dates,…