-
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…
-
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
I'm moving a sheet over from Google Sheets. Right 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…
-
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.
-
Hyperlinks do not work when sheet is exported
Hyperlinks for sheets do not work, when the sheet is exported to a pdf. However it does work when exported to excel. Any reason for this ?
-
Predecessor with Calendar Days on One Item
When invoicing, we use a NET30 policy where the payment is due in 30 calendar days. The remainder of our project timeline functions in working days (Monday - Friday). I want the "receive payment" step (line 31) in our timeline to be dependent on the "send invoice" step (line 62) and to appear in the tasks when the invoice…
-
Merged: Create report off of a sheet you are working live in
This discussion has been merged.