-
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?
-
Attempting to convert data from check boxes to Multi Select Dropdown
Thank you in advance for any help you can provide. Since the Multi Select Dropdown option was not around when we created our form, we used a variety of check boxes to gather the required data via a form published on our website. Now that the Multi Select Dropdown is an option, we would like to migrate that data over to a…
-
Using Microsoft Flow to Send Email
Hello, Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an attachment of various do's & don'ts. I think I've got my flow set up ok but I'm…
-
Colour grading
Hi all, Is there any way that i could, based simply on ascending order of numbers, colour code a full column, as i have in the picture below? Thanks.
-
Pull Data from Master sheet to another sheet
Hello, I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. I need a separate sheet so I can use it for widget in my dashboard. I don't want to filter or sort the main master vendor…
-
Individual task lists for unlicensed users
Hello, can an unlicensed user see a list of all tasks assigned to them (across different sheets)? Our resources are frequently unlicensed as they only have to view the tasks, so they can't create reports. I guess the project managers could create reports for individual resources, but the problem is that not all departments…
-
Forms
Is there any way at this time to add a photo into the title area of a form? IE on the one beneath where it says, "SmartSheet Popping Plate" Would there be any way to put a photo there of say a company logo?
-
Reference main table to populate a new subset table based on conditions
Hi, I created a workspace that contains a list of project folders (and its respective sheets, reports and dashboards). I'm looking to produce a new consolidated Master sheet based on multiple criteria from each main reference sheet found in the workspace. In the simplified example attached, the new master table must be…
-
Flag By Issue Status Formlua
This seems so basic, but I cant get this formula to work. I have a flag colum that I want the flag to be 'flagged' if the Issue status column has an issue listed as "Open" This is what I'm using and getting an unparseable =IF(Issue@row = Open, 1,0) Thanks in advance!
-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…