Formula Issue

S_W

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,

 

 

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

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