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 2016 Posts
Archives for September 2016
Discussion List
Smartsheet SPI
Has anyone developed a project schedule in smartsheet that calculates SPI? If you have, would you be willing to share?
Start Row ID part way through a new SS
Dear SS Guru's we have a smartsheet that has been imported from Excel. and each row has a four digit 'DVS' code that i want to automate. I can create an 'auto number/created date' column but because over time some rows in the excel doc were deleted or becuase numbers have been assigned out of order they do not run…
Images Add-On in Google docs/Smartsheet Webforms
I love that I can create a web form for my employees to record data and upload pictures to the sheet. I commented on another thread on this topic in July and, just wondering the status of making pictures available in google docs merge? Or does anyone have another product or workaround? I am trying to create a pdf document…
Timechart in smartsheet or smartsheet labs
In smartsheet labs, I build a pie, bar and other charts based on my smartsheets data and it's really great feature. Unfortunately, i cannot find a capability to build a timechart, that is with time X axis and value Y axis. Tme X axis should take the time from the creation time of the record in smartsheet, and it would be…
Using AND and ISBLANK in nested IF statement
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…
Formulas to calculate data received from web form
This is a screenshot of my page that I want to try and get the formulars for. The cells that are in yellow, the data in those cells will come from my staff that I have complete the web form that i have attached to this sheet. The red cells are the ones that I require the formulas for to calculate the different times that I…
Automating Parent Row based off BRYG Children Rows
I am looking for a formula that will mark a parent row "Green" when and only when all children rows have been marked "Green" for completion. Each children row has a formula that bases of when each task was completed by date and will mark that row "Green" for completion dates that are today or in the past. Thanks, Josh
Old Filter Options
Before the 22nd Sept update, SmartSheet had a simple filter option where you could select multiple values from the column to filter on from a list (where the column was free text, not a combobox). Does anyone know how to access this behaviour, or was it removed. It was similar to how the Excel AutoFilter behaviour works.…
New Filter Options
I am so excited with this new addition of Filters. My questions if you set a filter and schedule it to email from that filtered view will that filtered view be what is sent each time according to the schedule. Example I have the sheet currently filtered for Last 7 days entries. i have set it up to send to designated…
Name instead of email address of the person created the row
I used this "Auto-system - created by" column property and what appear in the column is the email address of the user who collaborator who created the row. Is there a way to changed it instead to the name of the user who created the cell. Thank you.