SharonR’s Profile

Community member since May 2018

points
101

3

NETWORKDAY/S  

Can why does this formula above give out different numbers when the start and end date (automated by column) are the same. 

Eg... 

=NETWORKDAYS(Date created, Date modified) = no of days

Date created column = 01 august 2019 (tues), Date modified column = 01 August 2019 (tues) = 1

On

4

Hello, 

I am needing help with this formula

=IF({Colunm Range 1} >= 10, "Met", "To be Started")  (this works but will not be relevant for the whole year.)

How can I add in a date?  I was this formula to recognise if a range is equal to or great than 10 after the 01/03/19, "Met', "Risk"

 

Also can

1

I was just wondering if there is a way to track the usage of each user on an account.  For example, how often their log on,  how long they are logged on for, any active time in Smart sheets?

These stats will give my manager's insight on how useful the tool/resources is for the office and pinpoint

2

Hello, 

How do you save your sheet to be viewed as card view every time.  I am not sure how the sheet orginated,  may have been a previous template for project management.  But people that are shared to the sheet open it in Grid view,  any suggestion on how to save it to card view every time?