I am having some trouble with using the LOOKUP function on a sheet I have. We want to use a form to create a ad placement name that includes abbreviations of what the user selects. I am finding that t…
Hello all! I'm pretty sure I saw this functionality in one of my Engage sessions, so I'm crossing my fingers that there's a simple fix! I'd like to create a form that would allow individuals to submit…
Hi all, Is there a way to add a column which displays the ParentID to a Smartsheet? If I had this, I could produce the report I am trying to build I expect. Hep appreciated! Thanks, James
Hi, I have already set up the notification. In my Smartsheet, there are a few columns. One of column is "Mail Out". In this column, pre-set has two answer only: yes , no. In each row, there is an atta…
I've researched this and cant find a solution. How can I set up a CountIf formula for ONLY if Parent Rows are checked in an entire sheet? I can do this for the children rows but cant figure out how to…
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, I…
Hi all, At my job, we have been using SmartSheet for a while to manage our service projects. I am now starting to use Zapier to automatically create a new line for a project in SmartSheet once an uppo…
Hi, This one is pretty easy in Excel but I have no idea how to do that in SmartSheet. I have 3 columns in SS: Fruit, Brand and Price [Fruit]1 is Apple , [Brand]1 is ABC Ltd. [Price]1 is 100 [Fruit]2 i…
Does anyone have a formula that will calculate the following: Reaming = 194 Deadline = Sept 29 X = How many do i need to complete per day in order to make the deadline. Note: X should change based on …
Hello Community Team, I'm working on automating a % Effort column for my project plan. I need to avg the % effort at the parent level of its associated children. I want to do this automatically withou…
