- IF Statement for multiple cells with blanks
I am trying to create an IF statement which returns a status based on the status of 6 separate cells. How do I set the status to ignore blanks from those reference cells? For the attached example, the status should be set to "Not Started" based on the columns highlighted in blue.
- Moving Sheet Template with links to blueprint into another Workspaces
if you move a template from one workspace to another, would you lose the links associated to the blueprint?? I know you need to be an owner to be able to move the templates to another workspace but all the links associated to the data sheet fill in the blueprint, so if I move it to another workspace, then would I lose…
- How to combine multiple sheets with large volume of data
I have a large data set (9K rows + 250 columns) so it is broken up into multiple worksheets. Is there a way to combine? I have figured out how to build reports on multiple sheets, but not how to compile the results for a dashboard (ex: count how many records are across all sheets and have this on dashboard with a breakdown…
- Sheet - Format Cell Border
The ability to format cell borders with line style and color.
- Issues with DDUpdate?
Hi SS Community, Are any of you out there using ddupdate.com to support populating your dropdowns from a column in another sheet? Several people in my org are having trouble getting our payments to go through and are hearing nothing from the site. Is this just us or is it a wider problem with ddupdate?
- How can I create a sheet that counts occurrences of a word in multiple sheets?
I would like to create a sheet that tallies up all the instances of certain words, such as 'retain', 'rotate', 'textile', etc., from multiple sheets. So it would look like: Retain - 30 Rotate - 50 Textile - 20 etc. Is this possible?
- How can I best organize lots of different 'tags' to sort through
我从谷歌移动一张表。正确的now we have a column for 'Specialties' for different medical providers and it contains keywords we need to be able to search by. I need to be able to sort through this data quickly. I don't necessarily want it as a drop down because there are over 100 different…
- SmartSheet bar at top of dashboard
I've created a dashboard that I use in SmartSheet and have embedded in our project's SharePoint site. Unfortunately, at the top is has our logo but the background color behind it is so dark, parts of it blend in. (see image below) Is there any way to change this? I've gone to Personal Colors& Logo but it only changed it…
- Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
- Locking row when being edited without saving
If several users are utilizing the same grid at the same time, the ability to immediately (without saving) lock that row from other users editing it would be amazing.
