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 October 2016
Discussion List
Year to Date calculation, This Year vs. Last Year
I am trying to do a year to date calculation on some sales data but would like to bais it on this years sales vs last years sales to keep track of how we are doing month by month. Do I need to do a horizonal lookup? A sumif? Is there a way to add a current date to the sheet, then simply do if sum if >= to this date? Please…
Photo image size when importing via Web Forms
Hi, Using a “Web Form” to import an image or take a photo adds the image to the attachment column in the row. And the average picture size from my iPad is approx 1.4 – 2.0mb. Now taking the very same picture via the "iPad App" using, Edit Row / Select Camera Icon / Take Photo… Inserts the picture “resized” into the cell.…
Can an email from another system automatically be loaded?
Hi have a survey system that sends an email to a user with an attachment. I would like to know if SmartSheet can automatically load that email into a sheet for future reference? The idea is to have the system automatically email SmartSheet and then it can be loaded - hope that makes sense
Block rows been deleted from editor?
Hi, I would like to block my rows have been accidentally deleted from other users who are Editor (Cant Share), and the users still be able to updated the rows progress. Is there any way to do this? Thanks Cheers Quece
Deliverables, Dependencies and parent/child tasks in Card View
Hi Everyone I am hoping that you could help me with a couple of issues I am having with Card View. I am using Smartsheet for project management, managing multiple projects with many milestones, deliverables and tasks. 1) How do I show deliverables in card view? What I mean is, if I have parent and child rows in the sheet…
Project Roadmap on Calender view of report
Hello, I have a master project list sheet setup. I am attempting to create a project roadmap so we can look at the big picture. I was able to create a report that shows every Active, On Hold and Not start project. Here are my two issues: 1. The calendar view will only view out to 1 month, is that the limit or is it a…
I'm interested in seeing out-of-the box, unique examples of webforms others have used in the past?
I'm specifically interested in seeing webforms that allow the end-user to update their timelines on existing tasks. Maybe webforms are not the way to go; maybe row requests? I'm open to any and all ideas and would be greatly interested in seeing real-life examples. Thank you, Crystal Lehto
COUNTIF substring or wild cards
I have a column of Part Numbers. Each cell in the column may have a single part number or comma separated part numbers. I want to count the number of occurrences of a particular part number in the column. I searched the help and community pages but wasn't sure what's the latest. Is it possible to use wild cards or any…
Nested Formula
How can I implement an IF/AND/OR formula to calculate the desired output? For example: if an item type=ROM Estimate AND accuracy>50% OR <-30% then YES, NO. OR if item type=Budget Estimate AND accuracy>30% or <15% then YES, NO OR item type=Definitive estimate AND accuracy >15% OR <-5% then YES, NO Any help would be…
Card view for reports
Hi All- I really love the card view but can't figure out how to see my reports in card view. I understand that there has to be at least one drop down menu for card view to be an option but it doesn't look like we have the option make any of the columns in a report with drop down menus. Is that correct? Is card view not…
