This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hey fellow AT users,
I’m trying to set up a formula that calculates the renewal date of subscriptions based on if they are Monthly or Annual. I currently have 3 columns that I’m working with: Frequency, Billing Start Date, and Billing Renewal Date (w...
I’m working on creating a Table that lists Expenses.
I’m currently using the following formula to populate a Title for the first column in the table based on columns: Vendor, Frequency, Price, Per Member Price?, Users and Total Due. The “Per Member P...
Hey @kuovonne,
Perhaps you are mixing up what belongs in the IF versus the CONCATENATE .
I probably was, I’m not the best at writing formula’s. :grinning_face_with_sweat:
I just tested your formula and that was essentially what I was trying to do...
Thanks @Rebecca_Elam for pointing out the extra comma. Having another pair of eyes definitely helps with some of these formula’s.
I ended up reversing the formula to CONCATENATE within the IF statement vs. trying to use an IF statement within CONCATE...
