MichaelTCA
MichaelTCA
Reactions
-
Re: Hyperlinks / Update Requests
@Erin Kim I guess my point was that you can't get a hyperlink within the browser through an update request. You can through a form because you can specify that the value is a hyperlink. I used multip…1 · -
Re: Countifs formula to count tasks in a range last 7 days to future 7 days
Hello @SS_user10294507 If this was a copy/paste of the function. Then there's no close ")" to your COUNTIFS function.1 · -
Re: Sheet formulas are not auto-updating until the sheet is opened
Hello @Ami Veltrie I believe it's still an issue. I update sheets with data shuttle using expressions, such as the TODAY() function within them, and that seems to also update the TODAY() function wit…1 · -
Re: Combining selected cells into one cell ignoring blanks?
Hello @toca1 Looks like you're biggest issue is with the range references. Set it up similar to this format: =JOIN(COLLECT([Helper Column]:[Helper Column], [First Column Name]:[First Column Name],[Fi…1 · -
Re: Count if Expiration Date is in the next 3, 14, 30 Days without counting Past Expiration Dates
@Ava Blessie The easiest way would be to create a helper column for the days remaining until the expiration date and reference that column in the function. =COUNTIFS({Expiration Date}, <TODAY(3),{…1 ·
