-
Calendar App Filters
Within the sheet/report, I have a Contact List column that contains multiple contacts per cell. However, when the Contact List column is used as a filter within the Calendar App, these multiple contacts per cell are not broken out into single values. Is there a way to separate values within the Calendar App filter? Or does…
-
Countif lookup by email/contact
Hello - I have a sheet ("Sheet 1") where users enter various entries/plans, etc. via a form and to associate it with themselves, I have them use their email address which logs into a contact column. In another sheet ("Sheet 2")- I have a list of everyone who is expected to put in information. I have a contact column with…
-
Multiple approvers on one row
Hello, I am trying to setup an approval that would have 4 contacts that need to sign-off. They are all from different departments, so they would be looking for different things in the approval. I would need all of the approvers to sign-off before the task status changes from "Ready for Approval" to "Complete". Is there a…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
SMART FOR ASSET MANAGEMENT
Hello, Is it ideal/ possible to use Smartsheet in place of CMMS?
-
Notifications using Summary Sheet
If I create an automation workflow to notify all contacts on a sheet, will those listed in the sheet summary be included?
-
Notifications, Report or Dashboard
i am new to smartsheet and using it to keep track of inventory across multiple locations which have different contacts by location. What is the best method to send a scheduled listing of assigned assets to each contact owner. Would like them to only see their assets and be able to change the location if they no longer have…
-
Datamesh Contact Lists
Hi, We are trying to use datamash to bring over contacts to the target sheet based on locations in a source sheet which does not seem to be working. We have multiple contacts enabled and this works fine with vlookup, but datamesh returns no results. Any Ideas??
-
I want to controll a resource that it is different allocations rate at each point in a same task du
I usually set allocations rates as average during term. But,When the task is long term, it is different allocations rate at each point in a same task. And if I set allocations rate to another task at low loard point,Smartsheet alert the over resource by caliculating rates. （Because of the allocations rate is average during…
-
Approval workflow
Hi Guys, Im new to smartsheet , please help me. I created an approval workflow then if the approver is not around how I am going to reassign it to other approver without breaking the approval sequence. Please let me know your thoughts. Thank you very much.
