-
CONTAINS formula not working
I am trying to count the number of times the number "1" appears in a range using CONTAINS formula. There can be multiples numbers within the same cell seperated by comma. I have tried doing it via a dropdownlist too but its not working. Hoping for someone to help. Thanks
-
more options for Calendar Default View in dashboard
I'd love the option to change the default view of a calendar in a Web Content widget on my dashboard! (I am linking a sheet, not a report.) Option to choose the default layout (currently defaults to 1 month, and it would be so nice to choose the default view!) Option to choose what filters are on or off (currently defaults…
-
Collaboration in Smartsheet (Saving)
Hello, I am just wondering what is the best way to work in collaboration on smartsheet. Currently when multiple users are working in the same sheet and one clicks save the other users data is lost! How do I prevent this from happening. What is the best way to guide the teams on how to work with each other effectively.…
-
Batch uploading to drawing register
We use smartsheet for our drawing registers but are having to upload each drawing individually. Is there a way to upload drawings in batches and each one automatically upload to a different row. It is very long winded at the moment the way we are doing it, especially when then having to input the relevant drawing numbers…
-
How to set up automatic notification when entire column meets the criteria?
We are trying to build a monthly checklist with various tasks our team members need to complete. Some of these tasks need to be completed before another task on the checklist can be completed. Specifically, we need our users to upload their payroll cash batches into our accounting system before another user can populate…
-
Merged: Ways to find what reports are running a certain sheet as it's source data
This discussion has been merged.
-
LookUp Results then Automate Resonse
Haven't had to much experience with smartsheet, other than setting up some connections and sheets. Trying to accomplish this automation though; I have a connection adding rows/updating rows when source changes. I want to make a form or dynamic view (if possible) that allows a viewer/user to enter a PurchaseOrderNo…
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.
-
COUNTIF is Not Working as a Sheet Summary Field
I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clearly are rows that meet the criteria. SHEET SUMMARY FIELD FORMULA: =COUNTIF(Fund:Fund, 160) Here is a sample of the data in my…
-
Filling a Contact List from another sheet
Hello everyone, I have a sheet that has a list of all of the managers and supervisors in my organization and I keep it updated monthly. I have another sheet that has a Contact List field and I am trying to see if there is a way to connect the Contact List field to the Sup/Mgr sheet, so that it automatically updates when I…