-
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.