-
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…
-
Downloading multiple files shows wrong file timestamp (7 hours in the future)
Downloading a single attachment from Smartsheet shows the correct file timestamp. But, downloading multiple files shows the File Modified date of 7 hours in the FUTURE. Another time, it was 5 hours in the future. The attachments were PDF's. This is on a Win7 environment. The data itself looks fine (inside the documents).…
-
Prepopulate a webform - Automatic Submit
I'm able to populate all the fields in my Webform by including the field details in the URL, Is there a way I can automatically submit this webform ? I'm trying to get data from a 3rd party package across to smartsheets without having to dig too deep into the API side of things. Thanks in advance.
-
Add formula to column without changing last modified date
I would like to calculate the number of days an item has aged. We don't currently use a "closed" date field, but rely on last modified. =IF(Responsible1 = "Closed", NETDAYS(Created1, Modified1), NETDAYS(Created1, TODAY())) Is there any way to add a formula to a column without triggering the last modified system field to…
-
Adding the business tools
Why couldn't I add business tools? Do we have to buy each? Or do I have to work with my administrator?