Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for September 2017
Discussion List
Add a column showing the ParentID (or SiblingID)
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
Project Parent Hierarchy not shown in PowerBI
Hi there, I am trying to connect Smartsheet and PowerBI, so that I can visualize data in PowerBI from Smartsheet. I have the connector working, and can pull data from Smartsheet, but it pulls the basic data (row level) for all rows with no way of distinguishing a child row to a parent row. So where I have roll-up…
Show Value Sum of total Parent Rows checked.
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 do it only for Parent rows. Also, Can I place this formula on the checkbox column (at the very top for a total) and show a…
NEED HELP!!
Hello, I am trying to take 2 rows and combine them to one. They started as 2 separate projects but are now under one estimate. Is this possible? Or could I hyperlink on to the other?
Formula for SumIf
need formula for adding total from column if it meets the criteria from another column =sumif(Division4:Division16,LSG,[Q1 AOP]14:[Q1 AOP]22)
Design Error for Resources Allocation - Percentage vs hours/days/weeks
Edit - I may have been a bit harsh calling this a design error, I do see cases it would be easier choosing percentages for resource allocation instead of hours/days/weeks - but making the latter an option would be an amazing improvement. The current design seems relevant for a projectized organization with dependables and…
Formatting Parent Rows
Is it possible to format a parent row based on the number of children rows under it? If so, could you take it one step further saying like, highlight the parent row green if there are no children rows, yellow if 1 and red if 2. etc Thanks
Email signatures
It would be great to see a feature that when we email a row or send an update request, we have the ability to add a branded email signature. Does anyone have a solution to this? Thanks, Lucy
Maintaining Formulas When Sorting a Sheet
Hi, Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was moved to. My formula is a COUNTIFS and I want it to count what I am asking regardless of where in the sheet the row where…
Can one Site call another Site
We put on events and each event has a sheet and a Sight. I have created one Sight with information from each of the event sheets, but I want to drill back to that events Sight and not to that events sheet. Is there a way to do this?