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...
