-
Re: Count cells containing text only, excluding text with digits
@Salèha El D. Is the number always on the right? If yes: =COUNTIF(Names:Names, IFERROR(VALUE(RIGHT(@cell, 1)), "OK") = "OK") If no: =COUNTIF(Names:Names, NOT(OR(CONTAINS("0&q…1 · -
Re: Trying to get a dashboard to update with the most current entry.
@Dustin AK Lean VA You will need to have a calculation field. If you add rows to the bottom: =Index([Weigh-In]:[Weigh-In],COUNT([Weigh-In]:[Weigh-In])) If you add rows to the top: =Index([Weigh-In]:[…1 · -
Re: Hyperlinks within Forms - Force Link to Open in Separate Tab
If you add &target=_blank or ?&target=_blank (if there isn't already a ? in the URL) to the end of the link it will force it to open a new tab. Example: To open this page you would use https:…9 · -
Re: VLOOKUP help formula
@laura.sandoval Just coming back to this... glad it worked for you. The closed parenthesis in the wrong place gets me all the time too. @Genevieve P. thank you for adding clarity to the formula!! 😀1 · -
Re: Countifs with date criteria and also parsing drop down
@Ben77 You were really close to getting it 🙂 =COUNTIFS({IC Issue Tracker Range 7}, >= DATE(2023, 2, 20), {IC Issue Tracker Range 7}, <= DATE(2023, 2, 26), {IC Issue Tracker Range 2}, HAS(@cell,…1 ·