エンタープライズ向けに構築

Need the minimum start date for projects, what's the formula?

Need the minimum start date for projects, what's the formula? ... Best Answer

Alert Someone Automation Stopped Working

Here are some steps and considerations to help troubleshoot your automation issue: ... Notification Preferences: Are you testing with your own contact as part of the Department contacts? ... If so,...

AVG formula #DIVIDE BY ZERO

Hi @DG 13 ... The #DIVIDE BY ZERO error occurs when your denominator is zero. ... In this case, if you are trying to calculate the average for the number of items that are not started (for example)...

i want multiple approvals from an automation workflow to be in an email. is this possible?

i want multiple approvals from an automation workflow to be in an email. ... Purnima Gore_PGPS ✭✭✭✭✭ ... 01/17/25 ... Hi @kelly9838 ... When you create the approval email use the weekly trigger and...

Can I start my project codes from zero for the 2025 year?

Can I start my project codes from zero for the 2025 year? ... Im creating the identifiers using this formula, ... To populate the suffix helper we used this formula, ... =IF(YEAR([Project Intake Da...

Is there a way to see the emails that a form was sent to?

Is there a way to see the emails that a form was sent to? ... 01/21/25 ... Hello @dnavarrete ... I don't believe there's a way to see which email addresses were provided and emailed upon form submi...

Sharing Report but Not the Source Sheet

01/21/25 ... Hello @Jade Boring ... The functionality for sharing a report without sharing the underlying source sheet is said to be coming soon. ... Meanwhile your question has been answered sever...

Need formula to remove characters from a column when added

Will it always be all text after the < or > that needs removed? ... Correct. ... The people using the form just cut and paste the data in the column and we are trying to elimintate them having to m...

How do I add a date range formula to an existing formula?

How do I add a date range formula to an existing formula? ... It looks like you are using Excel syntax. ... I removed the first two {Ranges} because you have no criteria for either of them. ... Wha...

Form Submitting Error when attempting to submit with an attachement

01/20/25 ... Hey @NickBlocker ... I'm unable to replicate what you're seeing: as long as the file is under 30MB then the Form submits without an error. ... Is this still happening for you today? .....

Formula help - How to return which Financial Quarter a project Start Date falls into

@Tara Factor I also thought of a more elegant solution that will allow you to use your second sheet and keep adding new quarters as you identify them that way you don't have to keep modifying the f...

Formula help on RYG Balls for Baseline Variance

Create a helper column and use this formula: ... Then base your IF statement on the formula. ... You could also build the formula into your IF statement to avoid the helper column. ... 0 ... 01/20/25

countifs help

@tracyashton The other thing I thought about is if you need to return a total that consists of all of the cities you listed you could use COUNTIFS with an OR function, as pictured below. ... That w...

Countifs return 0 out of nowhere

01/20/25 ... Your formula looks fine, but that would make sense if it were previously working. ... Is it possible something changed in your source sheet? ... If it is populated by formulas or data ...