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
Creating a sheet for duties ~ limiting the participation.
We are in need of a large number of volunteers to assist at an event. We want them to sign up for specific days/times. Some of the positions need a specific number of people. Can I close the option once that number is reached? Thank you!
portfolio roll up - Waterfall and Agile templates
Hi, I use waterfall and agile methodology as per project requirement. I am creating a portfolio master roll up report for executives. When I pull all the projects, it pulls only waterfall templates ( yellow row). How do I make sure it pulls agile projects too( organe row)?
CountIfs and Blanks, not blanks
Hi Guys I have two columns of data that I want to summarise with a count into a specific cell where the follpowing conditions are true: The first column is NOT blank AND the second column IS Blank. Not sure if CountIf's is right for this. Any help would be appreciated! All the best Barry
How to avoid tasks being split across days
* Hi * * with a sheet that has dependencies enabled, is it possible to avoid having an activity (e.g. a training course, lasting say 3 hours) being scheduled across 2 days (or a weekend)? Thank you!
Reports and Pagination
Hi! I've written a google script that mirrors a smartsheet - it checks hourly and syncs the google sheet to reflect the latest info in smartsheets. It works great with sheets, and all of the rows populate correctly. However, when I switch the target to a report, only 100 rows will sync. When I switched to looking at a…
The row is not street when I insert Korean language.
Hello. I have some problem with smartsheet. The problem is When I insert Korean language, the row is not street line, and the focus is not position in correct place too. How can I resolve the problem? Thanks a lot.
Update row Webhook triggered when filtering rows...
The update webhook got triggered if I delete rows and also when I filter in my page. Is there any way to avoid it and get only webhook when data changes, not if a row is filtered, deleted or moved? I'm working wht zapier, and I get a lot of "false" updates due this issue.
Smart Sheet labs - map
Hello I'm creating a map in Labs and 13 addresses will not populate. All have been verified as correct. Any ideas why this might happen?
Smartsheet SPI
Has anyone developed a project schedule in smartsheet that calculates SPI? If you have, would you be willing to share?
Date Added Field - Auto Fill
Is there a way to create a field that auto fills with today's date every time a row is added to the sheet? My end-goal is to use the Card-view to organize my tasks, and the auto-date to export this list and create a "burn down" chart in Excel, with other metrics, to track my personal efficiency.
