I am trying to build a Finance sheet for a project and I want to be able to type in the project code and to pull the info from the Metadata sheet into the finance sheet. I am using a combination of th…
I am attempting to match multi select criteria in one sheet to the corresponding contact list in another sheet. The multi select column has over 100 possible criteria, though the average cell has 3-4 …
Hi Everyone, Hoping I can explain this well so that someone out there can help me with this. I have built a solution that is quite complex and moves projects around to 3 different sheets. The intake s…
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecess…
My boss recently challenged me to see if I could add some logic to our project plan smartsheet templates where if a user entered in an Assigned To column can dynamically narrow the values available in…
I am struggling with this formula. My Syntax is correct, the lay of this formula works until I add my date range. I have tried having both my formula column and the referenced date column as date, dat…
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52…
Hello, I imagine the answer(s) to this question already exist but I haven't had luck finding them, please point me in the right direction, here's my situation: I have a Smartsheet ("sheet 1") that my …
Hey! It's my first time posting here, and I really hope someone can help me! 😄 I have a formula which I'd like to modify. I will explain what I have and then how I'd want to change it. I have a formu…
I understand that I cannot bring over the end date from Jira to Smartsheet when there is dependencies/ one directional. Does anyone have a tip to use a duration field in Jira to populate the end date …
