The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi everyone, two part question. Can I identify based on the color of the single-select option, and can I display the field name as output from a formula?
I have a project tracking sheet with ~10 task fields, and a color coded dropdown status for eac...
OK, looks like on “Member Attendance” your “Membership Entry Count” formula is currently:
IF({Passport Booking}= 'No' ,1 ,0)
Try adding a conditional IF to check for the date compared to renewal date… and 0 if it isn’t whatever you want.
I think you’ve already done it… just need to add a filter (sum is at bottom of entry count column if that’s all you need)
good work & thanks for all the new contact info for my Philippines spam list! seriously though, so nice when someone shares a...
at the top of the form you can add a description, in each field you can add help text, and for single-line text records you can set a default value. if it can’t go at the top, maybe just have an optional comments box.
melinda, just saw I was respond...
highlight column a, then data menu --> split text to columns
looks like google sheets actually keeps the ) so you could use your same regex formula.
from there, you can isolate which photos have more than one image, because there will be info in co...