Hi - I'm relatively new, have watched videos and searched articles but I'm stuck. I have 50+ training products and a ton of potential job roles and location combinations. I'm trying to use SmartSheet …
I have a column in my sheet that contains a list of names of people that are attached to that record/row. I would like to add another column that displays the number of words in that column - just a c…
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically ca…
Hello, I want to count the cells that contain a certain name in the assigned to column on one sheet only if the task start date is within a certain date range i.e the current week. For example, count …
Is it possible to combine multiple formulas referencing the same cell without running into a circle reference? Similar to passing an object to a function. I would like to combine the 3 formulas below …
Hi, I am trying to convert a number in millions but shown as a thousand to the nearest decimal point and then add "M" to the end of the converted number. I understand the formula to divide by 1000 and…
Hi, Is there a way to find the Grandparent or Parent has a particular string/word? I have tried PARENT(PARENT()) and ANCESTORS(), didn't work. Appreciate any help.
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the …
Hello, I was wondering why the formatting of this document is auto-crossing out the actual calculation? Is it suppose to be doing this? Is there a way to make it not do this?
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of th…
