Hi,
I would like my first column to be a formula that combines columns A-B-C if a specific value is selected in a single select column and combines different columns if another value is selected in that same single select column.
I have a single sel...
Hi, I am interested in using a conditional formula to either automatically select from a single drop down or to use a phrase with emojis.
{Program Status}
In this field I want to indicate in one field if a program is:
In Progress
Complete
Future
{Pro...
I would like to utilize a formula to calculate pricing that is contained within Single Select text.
One of my fields includes a Single Select drop down like this:
Heading: {Initial Program Cost}
325 for Massage (first 3 hours)
The next field includes...
Hi,
Thanks for the reply! I just can’t figure out how to combine these two ideas. I’ve been stuck for hours. I understand in concept what I want, but I don’t know if I have a small syntax error, or a larger problem. Any ideas?
Thanks,
Alix
Thank you! I tried this, based off of what you wrote, and it worked! Amazing!
(VALUE(LEFT({Initial Program Cost},FIND(" “,{Initial Program Cost})-1)))+((VALUE(LEFT({Additional Hourly Cost},FIND(” ",{Additional Hourly Cost})-1)))*{Additional Hours})
