This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi all,
Looking for a way to have a URL button open a Google News search with the terms in the first column. I tried this: (https://www.google.com/search?q={Tax Change}) (tax change is the name of the first column), but it’s telling me I still have a...
Hi! Our team uses a collective base for task tracking, but folks are interested in being able to house both those tasks and their own separate to-dos in a separate base. Our initial thought was to have everyone create an individual base that would pu...
hi all –
Trying to help my agency put together a menu of deliverables that we can use with clients to help them plan their budgets/programs for the upcoming year. Essentially the base needs to cover:
what the deliverable isestimated time in hours to ...
Hi all,
I’m looking to create a formula to show a :rotating_light: when a record’s status is “PENDING” and it has been more than 10 days since it was updated. I’ve tried doing this a few ways using both a column with the Last Modified Date field, a...
Kamille_Parks:
"https://www.google.com/search?q=" & {Tax Change}
Thanks so much this was super helpful! This works to open a main google search, but I’m aiming specifically at google news… any thoughts on how to do that?
W_Vann_Hall:
IF( AND( {Status}=‘Pending’, DATETIME_DIFF( TODAY(), LAST_MODIFIED_TIME( {Status} ), ‘days’ )>10 ), ‘ :rotating_light: ’ )
i had retyped it but just tried copy/paste and it worked!
Thanks W! Tried this and was told the formula was invalid. Followed your tip and changes TODAY() to NOW() and got the same thing unfortunately. Any other thoughts? Appreciate your help!
