Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
How do you write a formula to count certain values of an adjacent column from where you want to the count value displayed. In my sheet I need to count open positions and filled positions based on the status. My sheet is very large so I have to replicate this many times with varying row #s so looking for a quick way to tell the sheet to count the values of children rows in the status column.
Thanks in advance!
Hi Summer,
Not sure I follow! Do you want to COUNT or SUM the children of specific rows? Do you want to show the calculated value on the same row as the parent?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
The below formula should give me the total price of a project filtering it by the panel name and the area. I do not want to include a certain supplier. Also Level 1 is totalling the child rows, so I want to filter that out as it give an inaccurate overall total of the price allocated to the panel and area. I can't figure…
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
I have an automation that runs every morning at 5:00 am ET that copies a row from one sheet to another sheet. I received this error in the Action block in the source sheet: Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet. Originally, I had a system Auto…
