-
I'm having trouble with a formula
I want to count the number of Unique Programs when Project Status = Active and Department = Professional Services Based on my example I should get the count of 4 I have tried several combos of COUNT and DISTINCT but may syntax is all wrong
-
Folder Order
Hi - I am new to Smartsheet and trying to figure out how to move my folders and place them in the order of the workflow I want.
-
Reports and Sheets limited to printing 100 images only
One of the team has asked about printing to PDF a Sheet that contains more than 100 images embedded in the Sheet (not attachments). When attempting to print, only the first 100 lines of data is displayed. Has anyone worked out how to overcome this? (I don't want to have to separate PDF's.)
-
Collapse Columns
Similar to how rows can be indent or outdented and then collapsed/expanded I would like to see a similar feature for columns. i know I can hide columns but this would be different because It would be collapsed under a section.
-
Is anyone using a "ai service" for meeting notes and importing into smartsheet?
Hello - we track client meeting notes for our projects in a smartsheet. We use a parent-child relationship for the meeting titles, and the children are all of the topics. We track open and closed items with assigned to and dates. We might have 20 meetings for a client. It works pretty well. We are recording the meetings…
-
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…