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?
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
