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.
Discussion List
Formula to return Parent name of child?
I'm trying to figure out how to return the name of a child's Parent. Example: Parent 1 * Child 1 * Child 2 * Child 3 Parent 2 * Child 4 * Child 5 In the above, I would love to have a column on Row Child 1 that automatically returns "Parent 1" and for Child 4 returns "Parent 2". Is there a way to have a formula function…
Formula to move a row to another sheet?
Good morning, I'm hoping I can formulate a column so that if the checkbox is checked, it will move that row to another specified sheet. Can this be done? If column A is checked, move to Sheet B is the basics, but formulas always mess with me. Blessings, Loann
Feature Request - Auto format for ranges
It would be extremely convenient if we could set our autoformatting rules for a Row, a range, or even the whole sheet, instead of just one column at a time as is the current configuration. EXAMPLE: I have 15 columns that I would like to apply the same 6 formatting rules to. Currently, that means that I have to define 90…
Add blank row in Report?
Hi, I have a report that lists all tasks "due today" from different parent subjects. Is there a way to automaticlly insert an empty row in between each "subject" so the report does not looked so cramped? Thanks.
ROW ID
Is it possible to create a formula that populates a cell with the ROW ID? This is to set up some triggers using zapier
creating a new user group by importing emails
Hi all, I have created a survey that I want to send to about 250 people. Most, if not all of these users are already in Smartsheet (at a global level). I've created a Group called "survey list" and want to add these 250 people. I exported these users to Excel and did some magic to create a comma separated list into a…
Sight Enhancement Roadmap
Hey guys, I'm using the API to create a sight, and I want to load image via URL rather than directly inserting them. Is this currently possible, or is it maybe part of the upcoming enhancement? I'd like to be able to update the images on a daily basis via URL, would that be possible? Best.
Status View App
Has anyone played with the new Status View App. It looks ideal for what we have in mind but wondered if anyone here had tried it?
Project Timeline - Today Bar
Is there a way to add a vertical bar to a gantt chart to highlight the current date?
Reporting in Parent/Child format
Hi folks I have a simple sheet with many columns. It tracks all the projects we have and what stage they are in. The parent child relationship looks like this in the primary column: Project A Initiation Planning Execution Closeout For my report, I'd like to still show that relationship so that the gantt chart can be…
