Formula Issue

Hi all,

would anyone let me know of any 'string' limitations in smart sheets when creating a formula?

I have attempted the below in every conceivable possible way and I can only think that the formula is technically too long.

I am trying to complete the below:

GDI End date before today and complete <> 100%
OR
GDHV Portadown End date before today and complete <> 100%

(See image below)

I then need to add all the other companies into the formula I have going out to the right.

Thanks a million,

Screenshot (185).png

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi,

I don't think it's the formula that is too long (the limit is 4000 characters).

I'd be happy to take a look!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

S_W

Hi Andrèe,

Thank you so much for your reply, basically, we want an automatic Flag status that will uncheck, when all the status columns reach 100% before or on their due date. There are about seven companies that this will require, see screenshot.

Thank you so much for your help, I really appreciate it.

Siobhan

Screenshot 0.1.png

Andrée Starå

Happy to help!

Could you share your sheet(s) because that would make it much easier to help you?

You could make copies of the sheet(s) and if there is any sensitive information you can remove it.

Share to andree@getdone.se or let me know if it's not possible.

Best,

Andrée

S_W

I have shared that with you there, thank you so much for all your help!

Kind regards,

Siobhan

Andrée Starå

Thanks!

I'll take a look and get back to you!

Best,

Andrée

Andrée Starå

Hi Siobhan,

I've shared the solution with you now.

Let me know how it works!

Have a fantastic day!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…