-
Match Statement with Multiple Sheets
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO") I have another sheet…
-
Free users can no longer use "send..." on a row
Hi, has something changed for free users with the send option at a row level? we have a number of admin users but also free users than will fill out details in a row and then click the row dropdown and select the "send..." to send a mail with the details filled out for that rown. Now when our basic (free) users select this…
-
Issue adding email address
Hi, Our organisation was merged into a new organisation, and I'm now trying to add my new email address to be the primary email address now that they finally closed the old email address. I tried to add my new email address, but it comes back with en error message saying that my new email account is already associated with…
-
Sharing a Folder in a workspace
How can I share a folder with specific people in a workspace while limiting them from seeing other folders in the same workspace?
-
Approval process form with custom comment field. NOT THE GENERAL COMMENT FIELD.
Good Morning all, I established an approval workflow with a loop by using this: https://community.smartsheet.com/discussion/how-loop-through-workflow However, i would like to track the comments of the Approver for example. Sure he can insert a comment in the general comment field but i would like to have a field only for…
-
How to configure my own Email as Smartsheet Notifications Email Address
Hi, I want to configure my own email address to send notifications to team. How can I send the notification from my email instead of notification@smartsheet.com. If the feature is not supported in Smartsheet, what workarounds are available for it?
-
Share sheet with everyone at your company (enterprise plan, auto provisioning)
We have an enterprise plan with auto provisioning turned on I would like the ability from the sheet sharing screen to invite the entire company and set their permissions (see screenshot ending 23). When sharing a sheet, is there a way to select the "Only available to users in the owner's account" instead of specific people…
-
Formulas In Templates Reference to another Sheet
Is there a way to save a sheet as a template that has formula references to another sheet and be able to easily change the reference when using the template? I have a summary and detail sheet that I want to create a template for future use. The summary references the detail. I'd like the Summary sheet to maintain links to…
-
Cancelling account
We would like to cancel our smartsheet account, however our Administrator on the account is away on leave, and therefore we do not have the ability to cancel the account. How can we go about cancelling the account?
-
Option to deactivate an user
In shartsheet, there should be a option to stop a user from login (without making any changes with shared sheet settings). As of now, if a employee leaves the company, we have following options to stop that employee from using the company's smartsheet * Delete user - But that deletes all records for that employee and its…