Sign in to join the conversation:
Hi Folks,
Is there a way to get the full URL of the current sheet so that path can be put in to a cell using a formula?
Hi,
How would you use it? What's your use case?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi Andree,
We have a master file, each row in that file has a project list sheet.
There are cross sheet formulas to feed data fro each project file back to the master file
One of the things we want is from the Master File, being able to click on the link to get to the project sheet for that row quickly. So if I can put the URL of the sheet in a cell that is linked back to the master file, there will be no need to cut and past the URL in manually each time back to the master sheet to show where the project sheet is.
Ok.
You could set it up with Cross-Sheet formulas.
Would that work?
I'm the admin of a workspace which contains 2 sheets: 1) "Source Dropdown Sheet" which should function as master dropdown list to feed other sheets (sample a US State dropdown column), and 2) "Source Sheet 1" in which I'm attempting to link the State column to reduce copy/pasting. However, after going through the process…
Trying to find matching serial numbers, then use delivery date of the first entry to derive support date of 2nd entry. The below works for the initial entry but the Extension Order gets #Invalid Data Type error. Thank you in advance for your suggestions. =IF([Order Type]@row = "New HW", DATE(YEAR([Delivered Date]@row ) +…
Hi all, I have a formula such: =COUNTIF({project rel +2mos}, >=TODAY(+60)) that is returning a 0 count, even though there should be a count there. I do have the specified column I'm calling set to "Date". Any help greatly appreciated!
