-
Resource Check Out
Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was checked out by a different staff member? regards, Brian
-
Tracking Data / Shared Sheet
Hi! I'm really enjoying Smartsheet and glad we decided to go down the path of subscribing. While I was getting certified I found so many neat features and my mind just filled with all the things I could probably use various aspects of Smartsheet to accomplish. I ran into a limitation in my own scope that I'm sure…
-
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…
-
transfer user between accounts
Hi, I have 2 accounts, one with TEAM license, second with Business. I'd like to transfer 3 users from team to business how to do it? when I'll delete them in TEAM do they lost their sheets? or can I delete them in TEAM and add in Business without lost any data?
-
Dashboard formulas - Need to count if a person is included in Owner Column and the task is not close
Trying to calculate the number of tasks by person that are not closed. I currently have: =COUNTIFS({Tracker Range 6}, ="Andy", {Tracker Range 2}, <>"CLOSED") Where the Range 6 is the Owner column and Range 2 is the Status Column (Open, Closed, Hold). I am getting responses, but I think it is only counting where the owner…
-
Determine # days from 1 date range to today
Looking to assign a % complete to a project based on days from open to estimated close. Have a column showing total network days from these dates and now want to either nest a function to subtract the overall days from the current days (open to estimated close minus open to today). I am new to Smartsheet so am having a…
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Turn average working days to projected date using WORKDAY()
The basic ask is to calculate a projected due date based on historical data and duration that a certain task takes. So if x, y, and z parameters are checked, it will find the average amount of time (from a different sheet) that those parameters take and then calculate a suggested due date. I want to use WORKDAY(), but am…
-
Why is my formula UNPARSEABLE? Is it because of Dropdown Dependency?
It's a long formula - I want to make the number of starts in the "Current Status" column dependent upon the selection in the drop down from the "Contract/Grant Status" column: =IF([Contract/Grant Status:]1 = Submitted, "Empty", IF([Contract/Grant Status:]1 = Assigned, "One", IF([Contract/Grant Status:]1 = ELD Review ODE…
-
count if formula help
Was hoping to get some tips on the following use case. I set up a Smartsheet to track all my organization's training accreditations. This includes (student, assigned coach, product course, accreditation level, status, etc.). I want to create a formula that counts the number of open engagements per coach. This will help me…
