-
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
-
Clone Columns including Conditional Formatting
I have a Smartsheet that shows the status of an item by date and I'd like to be able to copy or clone the column with all the conditional formatting. Is there any way to do this?
-
LOOKUP & MATCH together
Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…
-
Webform vs Request Form
I really like the Webform feature. It's made things easier with coordination and data entry. Could I also upvote a feature for Request Form (as an extra step)? It would nice if the submitted Webform goes directly to the sheet administrator first to approve before it goes to a sheet directly. Not because it's been submitted…
-
Due Date is Past Due - Checkbox
I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%) I started with just the Adj End Date portion and have not added the percent complete to the formula. This isn't working... =(IF(TODAY() > [Adj End Date]5,TRUE,FALSE) I then want to do conditional…
-
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
-
Running Multiple Projects on SS
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…
-
Viewing PDF's on Android app?!
Hi, I am starting to use the Android app a lot more for viewing my sheet but when I go to open a PDF it just shows a black screen in the PDF viewer. Does anyone know what is going on? Thanks.
-
Feature Request: Customizable Daily Notifications by Time
Can we allow users to set their Daily Notifications etc. sent out at a desired time? This feature is useful while working with teams internationally and in different time zones. Currently, our teams in Hong Kong receive the daily notification email at 7 p.m. rather than their start of day.
-
"Master" or "Global" Sheet
I am new to Smartsheet and am using the 30 day version to determine if this app will do what I need. Two questions I have is in RE: to the Sheet. I run a PMO and have 12 PMs. 1.) Can I create a Master or Global Sheet and lock it down so the PMs use that sheet I have created which has specific Milestones, Q-Gates and Phases…