-
Formula for division (mix of information in a row and dividing by a number)
hi! In my Smartsheet tracker, I have a row titled "word count" and another titled "SLA forecasted time". In row "SLA Forecasted time", I need a formula which will be the number in the "word count" column divided by 2,000. EX: 6,000/2,000=3 . I have tried so many ways to get this thing done and it's not happening. Can…
-
Is there a way to populate a parent cell with multiple data entries from Child rows
I am looking for a simple way to have a parent cell list ALL of the different data from Child rows as text. For instance I have a project listed as a parent row with each part on the project entered as a child row. There is a column with different notes for some child items. Is there a way to make the Parent row populate…
-
Trying to get a dashboard to update with the most current entry.
I am building a weight loss dashboard for a client, that they can use for their clients. Everything is working how I want it to except for the current weight. I am trying to get that to update based off of the most current weigh-in weight that is added via the form. In the picture below it should be 180. I am trying a…
-
Helper Column: Checkbox Children from Checkbox Parent
I am trying to build the formula for a helper column that will check all the checkboxes of the children rows if the parent row has the checkbox checked. The formula works but it outputs "true" or "false". Is there anyway it can be checkboxes? I have a helper column called "Level" with parents as Level=0. =IF(Level@row > 0,…
-
Column selection for Sheet Summary formulas?
Hi Everyone, I am trying to select a row for a sheet summary formula, but it keeps giving me an #UNPARSEABLE error. It is working fine for other columns - however I notice on the ones where it is working the column range is linked, but not for the one I am having an issue with. Here is the one that is not working: Here is…
-
If formula
I have a form in smartsheet which has multiple tabs along with DIVISION. Issue is Crew members are entering the wrong division when they audit the data. My question is how do i add a division description box above the division tab? to give crew members idea about what division they fall in? and when ever a crew member…
-
Smartsheet formula
I need a Count If formula to give me a count of only the cells in a column that contain Yes, No, and to not count N/A, and by Quarter.
-
Ideas for a project/document management
I am looking for the best way to implement a way one or multiple people to review a document make changes to the document and after they make changes or decide the document is fine as is select a status of Need changes or no changes needed. My end goal is to try to use smartsheets to maintain the status of standards that…
-
Accurately Count if Multiple Contacts are in a Cell
Hi, I am really struggling trying to map out certain data points, when it involves our sales reps, because we can have multiple contacts in a single cell. In this particular instance, I want to find out how many quotes a sales rep has issued this year. Problem is, multiple sales reps can quote the same job, so another…
-
Cross-sheet referencing to count across multiple columns for a matching row. Can't figure it out :(
I created a metrics sheet that references my G-List sheet. In my metrics sheet I'm essentially trying to say, "Look at the matching [Ops ID No.] in the portfolio sheet (G-List) and count the number of cells across multiple columns that have no dependencies indicated (i.e. ="None")." The common column in both sheets is [Ops…