-
Vlookup
what is the best way to look up between smartsheets and keep the data fresh =VLOOKUP([Equipment ID]@row, {Equipment Tracker H5 RM 8.8.24}, 1, false) Equipment ID]@row = equipment id this sheet {Equipment Tracker H5 RM 8.8.24} = large data block in another sheet this works but will not refresh if data changes help
-
Team Member Contact shows as email address
Hi all, One of my team members was invited to our Workspace (before I came on board) with his contact name as just email address, while everyone else has "Name" then email address. In our ticketing sheet, we use an Assigned To column that is a Contact List and his name shows there but when I run a workflow to automatically…
-
Admin Approval Needed on Active Accounts?
How do you solve the "need admin approval" problem? Multiple people are having the issue where they have active smartsheet accounts within our enterprise account but are receiving the need admin approval error. I can send a password reset link and then they can get in but it happens all the time. I have a user who was able…
-
Merged: Please allow access to create formulas from reports
This discussion has been merged.
-
Bulk Delete/Deactivate Users
Add the ability to delete or deactivate many users at the same time. Currently this has to be done one by one so this feature would save a lot of time.
-
Change the JIRA account an individual Smartsheet user is connected to
We were in the process of setting up a generic user to create JIRA connector workflows and did not have a user created in JIRA that matched. One of our users mistakenly connected the generic Smartsheet account to his own JIRA account and now we only see his JIRA projects. We've been told the only way to reset this is to…
-
ServiceNow SaaS licensing integration with Smartsheet
Hello Community, We have successfully established the connection with ServiceNow. However, when attempting to pull user subscriptions from Smartsheet, we encountered an issue where only some users' subscriptions were retrieved, not all. Subsequently, an error occurred indicating:{"errorCode":1013,"message":"The operation…
-
Smartsheet University Progress Tracking
I would like the ability as an admin to see which of my licensed users have registered for a Smartsheet University course and track progress. Would be great to know who has completed the courses as assigned, and who has not without requiring them to submit their badge.
-
Adding free-plan users to organization
I am confused about adding free users to the organization. I have a number of full licences, with a number of free accounts collaborating as guests. Some of them have been able to sign up for the free account and they appear in the organization; however, others do not appear in the organization. What could be the reason…