I have a task list that includes what project the task belongs to. The project field is filled in manually (not a preexisting list). I would like to setup a dashboard to show a distinct list of projec…
Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added…
Hi I have two columns. One is called "Hierarchy" and the other is called "Description" I'd like to have "Description" automatically filled with this text/forumula "=PARENT()" if the value in the Hiera…
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original shee…
Hi all, I'm trying to have a link between a risk register into an issues register and I don't know if it's simply my code or if this isn't possible in smart sheets. I have a column in my risk register…
Hello all of my smartsheets are coming up with the message - more sheets referenced than allowed and I am not sure what to do about it as the sheets were created for me and i know they all link to a '…
I'm trying to use Zapier to input formulas into a Text/Number column (which does support formulas) and it comes over as a text string: '=INDEX(PARENT(), 1) I'm using Control Center which creates new r…
I use a smartsheet to manage engineering tasks I have columns that calculate task duration based on work types I now want to convert this to a project sheet and have the task duration driven by an exi…
Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets…
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the projec…
