-
Portfolio Reporting
I am new to Smartsheet and my goal is to have a dashboard for our PMO with links to the various projects. Each project may be led by different people in the company. Do you have suggestions on how to set up the Dashboard for automatic roll up of information? I have found some helpful articles here, but I would love to know…
-
SmarSheet Expiring for shared user and requiring subscription
Team! One of my clients is reluctant to use SmartSheets because she claims that when I share access and a certain amount of time has passed that she is required to purchase a subscription to SmartSheets. Is this true? I cannot find any documentation that supports this. Thanks.
-
Password Change Policy
Is there a way to set a password change policy? For example, I want people to change their passwords every 90 days. Can I set that to happen automatically?
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…
-
Auto Reminders
Hi, I just Created Auto Reminders in notification, if 'Date column' = Today & Name Column = "Jenn" then it should send that particular Row to "Jenn" email ID But It's working only whenever i am Saving that Sheet. How can i make it work automatic, even when i am not opening that sheet. ?
-
IPhone 7 Home Screen - Webform
How do I add a webform to the home screen of an Iphone 7? Is there such a feature?
-
Calculate days remaining
I have an estimated project Finish date of 8/9/16 in a column "Finish". this date is in row 6 and row 161. I have entered a row name TODAY and set the date to current date in the 'Finish" column row 4. I attempted to use the formula: =NETDAYS([Finish]6,[Finish]4) I get no result or error message. Just the formula. What am…
-
SUMIF
Hi all, I am trying to add a range of cells on condition that it does not contain any value that is equal to/or less than 0. for instance (12,45,24,0,65) should equal 0 and (12,24,24,10,65) give me 135. anyone to help?
-
Allocation in Template Sets
Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…
-
Rows of data moving
Greetings to all, At my work we have recently started using Smartsheet. We use it on a simple level, i.e. two or three users can update the same spreadsheet at the same time. We're a transportation company and we use the spreadsheet to schedule our runs and and update current runs after completion. What we have noticed,…
