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
[SOLVED]How to count the amount of children of a parent?
Greetings, and thank you in advance for helping a beginner at Smartsheet out. so thanks to the formel ="<PARENTNAME> [" + (COUNT(CHILDREN())) + "]" I managed to count the amount of children a parent has in the parent row. However now I would like to use that number(the amount of children) in a summary, but I just don't…
Formulas
What is the formula to add 90 days to a range of dates that yields MM/DD/YY as the result in corresponding cells?
How to write a formula to sum up child values into Parent row?
How can I write a formula that sums up all the effort (hrs) into the parent row for which those tasks are under?
Printing to a paper size with unlimited length
Anyone have experience printing to a paper size larger than D? We have a plotter and can print whatever length we want, as long as we don't run out of paper! Currently we are stuck with D size plots and it requires taping sheets together.
Pre Configure Report (Task list) for each Resource that will work on Project
Hi, This is probably a Feature request rather than a discussion as I do not feel that there is a way to do it at the moment, but I may be wrong. I would like to create individual reports for each of the resources U am going to use on the project. The Criteria being Assigned to (Contact Column) that resource. Problem,…
Sharing out Statistical Data
Hi everyone, What templates would you recommend for a report exclusively showing statistics? No date information will be included in this report (beyond the name of the month); however, there are three layers of statistics I need to share out by month. Any ideas? I look forward to hearing any and all suggestions- Alyssa
Smartsheet patch updates?
For at least the second time recently (since the May 7th update), I have been requested to refresh Smartsheet because of updates. The timing strikes me as odd to (3pm on the West Coast). Is Smartsheet pushing patches without updating the release notes? Thanks. Craig
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
Lock source links
I've created a web form that feeds a very simple tracking sheet. Each week, the person providing the info will submit their data via web form and the information flows to row one of the tracking document. In a separate sheet, I've created a dashboard that should, in theory, pull the latest data and compare it against…
Auto-Sorting Completed Tasks
I've done a bit of digging around, but wondering if I'm just not digging in the right places: What I'd like to do is set a rule that when a row is marked Done/Completed/Etc.. that it moves to the bottom of the sheet. Is there a way to create that kind of sort rule?
