-
Time
Hi all Is anyone aware of any time functions is recent updates, I what to be about to calculate how minutes/secs(don't mind either) from a system column also is there an hour or minute function in Smartsheet? thanks in advance
-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
Looking for General Help
I am relatively new to SmartSheet. I have been using it as a glorified spreadsheet for about a year in my small business. I opted for it due to the notification feature as I work remotely most of the time. As I always seem to do, if I figure out it can do "this", I think it should be able to do "that" but I really don't…
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Allow access to specific items only
Hi all, I am creating a set of sheets. * Main sheet: gathers all the tickets about issues raised from the field (customer). Ticket (row) will be added using a customized form. tickets are coming from several types of users.* Engineers that belongs to the company. * Engineers that are external and belongs to the customers.…
-
Comments In A Report
I am managing several sheets, and want to create a report for myself and the team that logs or captures all the comments that are associated with the sheet/tasks. I am struggling to find a proper way to include the comments (visibly in a report) Thanks for suggestions.
-
Hiding who is viewing a sheet
Hello! So I have been using Smartsheets for a short while and I think it's fantastic! I do have a query though - Is there a way of hiding who is viewing a sheet? We have a sheet with a massive amount of data on there which is shared with numerous suppliers we work with. They all require the data for different uses, some…
-
Stumped with a simple formula - countif with sheet reference
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE. What am I doing wrong? =COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker 2018…
-
Export smart sheet
Hi, I wish to export existing sheet data by last year month wise, i. e. i am using smart sheet since 2017 to till date, i am using smart sheet to maintain data and with getting updated by team, i wish to be have a data month wise which i haven't saved it on my PC and now i wish to see month wise data. please guide me how i…
-
Bank Statement Checklist and weekly notification of missing statements
Good morning, I am trying to build/find a Bank Statement Checklist that will notifiy me of all missing bank statements. For example, as of today, we should theoretically all bank statements from October 2018 and prior. I would like a monthly email sent out notifying me or somebody of all missing bank statements. I am…
