-
New Boardview
Hi All, After new ew boardview upgate the date format changed to American. I've checked Account settings and those are correct as Australian which is 23/07/2024. When I go to Grid view I can see Australian date format but on boardview is American. How can I fix board view to show Australian date format 23/07/2024. Thanks…
-
Formula Date Not Syncing With Conditional Formatting
Hi, I'm trying to automate my start date and due date columns. In order to do this, I'm essentially hard coding the month and day piece of the function (e.g. "01/01") and then extracting the annual piece of the function from the Task column (e.g. "2024" to "24"). The output, I believe, is similar as it would be in excel…
-
Can I add a time do a date field?
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?
-
Date from a Cross-sheet formula not converting to a Date when row is moved #Invalid Type Error
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…
-
I Need to set up email automation,
I need to setup email notification for 'Assigned To' contact list with respect to Caldue date coloumn. Every time I try the emails gets sent in to all the contacts in assigned to. Help me out ASAP
-
Cross Reference Sheet with Drop Down so I can use Conditional formatting
HI there, So I have a reference sheet, listing down all Australian Public Holidays by State (multiple drow-down). What I would like to do is to identify these holidays in my Destination sheet, and display if the holiday is either QLD, VIC or NSW or all three. I am currently using a helper column to identify if the dates…
-
Formula for counting days
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…
-
Formula for Quarter & Year
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.…
-
Enable End Date editing in edit panel of Timeline View
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,…
