-
Dynamic Durations
I would like to calculate the duration based on two tasks. For example, I want a start date from say task 1 to be the start date of Task 2, while the end date of Task 2, to be the start day of task 100. The duration should of Task 2 will now be the total number of days between task 1 and task 100. If I adjust Task 1 or…
-
Project sheet multiple users restricted data view
I have a question , If I create a sheet to track the tasks done by my team, is there a way where i can have that when each member accesses the sheet, they can only see their own inputed data, but for the admin he can see the full sheet without any problems ?
-
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?
