Sign in to join the conversation:
Hello all,
Maybe simple question, but I would like to have the a cel inside a smart sheet filled with the filename of the sheet? How can I do this easy?
e.g. CLIENT-001-sheet011 in a cell?
Thanks,
Eric.
Hi Eric,
Unfortunately, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
Maybe its possible thru the API or similar.
Another possible workaround could be to add the sheet name manually to another cell or column and then cell link to it.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Wouldn't be easier just to insert hyperlink to the other sheet? Then you'd have live link pointed to your customer's sheet as well as title you want.
BR
Marcin
Hello, I have set up a sheet in which a form will submitted with 4 columns; a specific label (from a dropdown list), and then up to three barcodes. On the grid I also have a hidden created date column. I am then wanting to create a separate sheet that collates the most recent barcode for each column for label for the day.…
Hello- I'm trying to build a sheet where i can open appointments chronologically after 75% of the appointments fill up. I currently have 4 appointments every 15 minutes. the only way i can think to do this is to add a sumsif formula and once 3/4 of the slots fill, to open the next set of appointments. if there's a better…
Hi all, I am trying to expand on my regular countif formula but I am getting an error. The original formula: =IF(Order@row = 2, SUMIFS({Costs}, {Date}, Date@row, {Location}, location@row), SUM(CHILDREN())) works perfectly fine. However, when I add onto this formula, I get an error: =IF(Order@row = 2, SUMIFS({Costs},…
