-
Log A User Out Remotely?
Is there any way to log a user out remotely? Someone with high priviledge who is away for 2 weeks has clearly set her PC to remember her log on details. Can I log her off and reset her password remotely? I have currently removed her priviledges as an immediate security measure. Thanks
-
How to automate recurring dates
I have a sheet where we are required to log certain inspections and tasks. The frequency of the inspection and task differs for each ie quarterly, six monthly, annually etc. The frequency is dependant on the first date ie 15 June then the next inspection for 3 months is 15 September (ie the dates are not fixed). We need to…
-
How to ascertain duplication of values in a sheet
What is the best way to determine if there are multiple entries of the same value in a sheet without using the search function? I need to know as part of quality assurance that all values are unique? Can this function cover the entire sheet or do I have to repeat it column by column? Thanks Mytch
-
Problem with SumIF
Hello @Craig and other Helpers i experiment the same issue than other sorry for my english but i m french i copy your formula below and try to adapt with "laserjet" type i want to make a sum if a name appear in the row i write it but doesn t work =SUMIF( [Syndic]1: [Syndic]1132]; FIND("Crouzet"; @cell) > 1; [Total…
-
SUM IF & LEFT @cell
I keep getting the result of 0 I am trying to sum a range if another column contains "Street Lighting" I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below. =SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to…
-
System Improvements for August 19?
I may have missed this somewhere, but I am curious what enhancements are slated to be implemented this weekend--August 19? Looking forward to some awesome new functionality! I appreciate any insights... Steve
-
Using Hyperlinks from mobile app
I have hyperlinks on a sheet that hyperlink to other sheets. When I click on them using the mobile app it opens up the row for editing instead of opening up the hyperlinked sheet. Any help on this?
-
Webform - Changing color for healiners, email,
First request, it could be helpful to have the heading “Required Information” in red font so it stands out. Feedback from the Controllers reaching my desk indicates that xxx had to verbally point those out to the controllers, so please let’s work on rectifying that. Also, under “Required Information” the person submitting…
-
Auto-Increment Change Orders
I have a column [Entry Type] which contains (Task, Change, Other). I use a web form to allow others to enter change orders. I would like to automate naming these change orders as Change Order 1, Change Order 2, Change Order 3, etc. I can use =COUNTIF([Entry Type]:[Entry Type],"Change") to obtain the number of change orders…
-
Creating/managing daily task lists
I'm new to SmartSheet, which my team has started using to manage collaborative projects. I'm trying to figure out the easiest/best way to generate a daily task list for myself drawing from the sheets I've created for the multiple projects that I manage. Your suggestions are most welcome!