David_Syre_Art - profile

David_Syre_Art · Jul 20, 2020

I have a base that contains records of artwork with record#s that contain letters. D for drawings, P for Paintings and S for sculptures. The prices for all the artwork is based on a formula derived from the dimensions of the art. Drawings and paintin...

David_Syre_Art · Apr 28, 2020

I have a number for every record in this format P01384. It starts with P00000. There are several records missing and I would like to see if there is a way to write a formula that would give me the numbers of the missing records in the sequence. Is th...

David_Syre_Art · Jul 20, 2020

Thank you very much @Zollie!!. Would it be possible to embed formulas inside the curly braces instead. At the moment there are two columns because P and D have different formulas to calculate price. I am looking to combine the two VALUE columns into ...

David_Syre_Art · Apr 29, 2020

Thank you so much. Not sure I understand how to proceed with the second, simpler solution. Will try to investigate more and see if I can figure it out. Incredibly grateful for your help.

David_Syre_Art · Apr 29, 2020

@andywingrave Thank you so much for answering back. Here is the way the table is setup. No linked tables. Example of a missing record. The scripting block sounds like a good idea. I have no scripting experience but can start looking to learn what I...

User Statistics

User Activity

IF Formula to apply formula

Finding Missing Numbers

Re: IF Formula to apply formula

Re: Finding Missing Numbers

Re: Finding Missing Numbers