- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 02, 2020 03:05 PM
I am wondering if I can take the column that’s titled “Client Lifetime Value” which is a numbers column… If the “Client Lifetime Value” is set at $37 I want it to print out “$37 Package Purchased” but if the value is $127 I want it to say “$127 Package Purchased”.
I would like these to show up in a Single Select column at the end of it so that the options are colored and easily distinguished. We use the single select options to ensure that the filtering for the rest of the spreadsheet works correctly.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 03, 2020 11:20 AM
Hi there – you can have a formula field output “X Package Purchased,” but it isn’t possible to formulaically change the value of a single select field.
For the former, the switch formula might be of interest.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 03, 2020 11:20 AM
Hi there – you can have a formula field output “X Package Purchased,” but it isn’t possible to formulaically change the value of a single select field.
For the former, the switch formula might be of interest.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 03, 2020 12:54 PM
Greatly appreciate the help, Pete! I will go ahead and. put that into motion. Are you able to color code the table based upon what it says? Just trying to make it more easily recognizable when someone is looking at the airtable base.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 04, 2020 10:17 AM
You’re welcome, Andrew :thumbs_up:
You can add color to your records on our Pro Plan.
If you’re sticking with the free plan, conditionally displaying emojis in a formula field (no joke!) is likely your best bet.
Cheers.