-
Difference between Team and Business Licenses
Dear All, New to the community. I needed to understand the main differences between the Team License and Business License. As small background, I am working in the PMO of a transformation programme and we are introducing Smartsheet primarily for maintaining the work stream plans and the overall resource planning. We are…
-
Looking for a way to send an automated email when using formula with TODAY()
Hi, I create a invoice register and would like to send out a reminder to manager for approval if there is no action by the manger after 2 days the invoice is raised. I set up a column called "Date pending for approval" with a formula "IF(OR([Approval Status]1 = "Submitted", ISBLANK([Approval Status]1)), TODAY() -…
-
Create a Live Mobile App For an "Inventory" sheet
We are a Masonry Construction company. I have created a smartsheet for Equipment Inventory capturing data for: total stock; stock used per job; stock available; out date; date returned. I want our employees to be able to quickly Note "equipment taken". Currently using "Forms", when a change is made, it puts all new data in…
-
Calendar - equipment booking
hi i am wanting to set up a calendar for keeping track of the equipment we hire out. i want the months /weeks/days across the top and equipment down the side. i can seem to get it to work correctly. any help would be much appreciated.
-
Automatic Capabilities
Hello, Is there any way to take the decimal and cents out of numbers without smart sheet automatically changing it to what it thinks it should be? i.e. 9,250,000.00 I would like it to read 9,250,000 Thank you
-
Staff Widget Production Tracking
I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which includes invoices processed,…
-
Restricting access to certain rows
I have a smartsheet for travel requests within an organisation of about 2000 people. Each row contains the requester's e-mail and details about date, destination cost and purpose of travel. I then use formulae to display remaining budget, etc. to approvers. Within the organisation there are about 15 people who can approve.…
-
Date format on workspaces
I had the following questions on date formatting: 1. If I change the format in personal settings (admin account), does it impact other users and their work spaces? 2. Can I maintain different date formats for different workspaces - say workspace one following US and the workspace two following UK? If not through personal…
-
Update Requests from Mobile
Why can't I send an Update Request from a row in the mobile app? I tap the row to open it to edit and I'm not able to send an Update Request. I'm on an iPhone, if that is important.
-
Enhancement Request: Find & Replace in Hidden Columns (Admin)
Allow Replace (Find & Replace) in hidden columns for Admins DescriptionWhen I perform a Find & Replace, I would like (as an Admin) to be able to Replace All in hidden columns. I can Replace All in collapsed rows, which is not quite the same thing, but they are not visible when first searching. OK, the hierarchy expands…