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
Auto Archive Completed Tasks To Another Smartsheet
Have a smartsheet with about 6,000 rows of tasks with 38 users updating. Since Smartsheet becomes very slow with that number of rows. As tasks are completed we use the move row feature to archive. However we would like to automate this so that when a task is completed it auto archives to another sheet. We have read that…
Changing Smartsheet layout and effect on Webforms
Hi, If I add new columns to an existing smartsheet (with webform), will I need to review/rebuild my webform, or will it still populate the correct columns? Thanks
Summary Reporting from a Single Smartsheet
I have a single sheet used to log test defects. From this sheet I've created a summary section at the top for Open Items and Items by Status. I need to create another summary "Item Status by Sprint versus Production". I've tried Reports but this does not allow adding a summarization of the data (equivalent to an Excel…
Zapier send mail when row is uptdated - trigger all the rows
Hi Is there anyone whit the solution for this problem ? I have been using filters and contacting zapier, but the recemand me to move the row i want to upate to the bottom. But thats not a good solution, because i use big sheet which is sorted.
Check box from Child row to Parent row
Hello, I'm looking to filter out a Parent row and all Child rows that have a drop down with a certain value, but with a twist. For instance, if a Parent row has a Status drop down value of "Completed" then that Parent row and all Child rows (regardless the value in Status drop down in the Child row) to be filtered out.…
Counting values within a column
Can you count the number of repeat values with a column. For example--building a board roster and want to identify gender. Can I create a formula that counts how many females are in the column at the bottom of the last row of the column? Looking at the formula worksheet it is suggesting =COUNTIF(Female:Female, Female1).…
Conditional Formatting on Linked Sheet
Hi Guys I have a sheet that is a programme sheet which holds all the high level data of each project within the programme of work. I have a cell called budget variance which I want to be formatted as filled red, large bold text across the whole line. I want this to occur when the variance data is more than £9999. Currently…
Summing Values
Currently I have a Spreadsheet that catalogs potential software enhancements. In order for us to determine prioritization we use a spreadsheet to calculate results based on a rating of 1-5 based on 6 criteria. We also assign each criteria a weight as some of the criteria is more important than others. I'm trying to create…
Card View Lanes / Drop down
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it possible to have "COMPLETED" as a lane on Card View WITHOUT allowing it to be a selection on the web form dropdown?
formula advise please
hiya, please see screen shots. I have a list of sales people assigned to target new customers. I want to know how many of their target customers are open opportunities (taken from a dropdown) but my summary table is picking up all the companies that have been contacted but are not suitable for any reason. i just need a…
