-
Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")…
-
[Need Help] Non-License user can hide column but can't unhide?
Hi, I understand that only License user can hide or un-hide column in sheet they are admin. * Hide/unhide columns (also requires Sheet Owner or Admin access to the sheet) But we have some user (non-licensed but part of our Business) that are able to shrink a column in a sheet they are admin, but they are unable to unhide.…
-
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
-
Cell Linking Issues
Hi all, Is anyone else having issues with cell linking? I can no longer get it working.... It was all fine until about 4 weeks ago and now nothing will link?
-
Embedding Tableau Public link to a dashboard
Hi there, I'm currently operating on an Enterprise level version of Smartsheet and experiencing an error with my dashboard. Does anyone have experience embedding a Tableau Public link directly into a dashboard via widget? I see that this is an option and have tried both the link & embed codes, which both return the same…
-
Help With Notification
I cannot get a notification to fire to the name in the "Assigned To" column when a new row is added. Screenshot is attached. Automation Permissions are set to "Unrestricted" The contact is shared to the sheet My personal settings are checked to include my changes in sheet notifications. And, I checked the SS status page…
-
Testing multiple due dates against completion dates
Hey Community members I have a sheet that is tracking reporting compliance. Most of the reports only have ONE due date (typically reported annually ie 30th June), but there is a number that requires monthly and quarterly reporting. To allow our users to enter up to 12 dates for a reporting cycle we have 12 fields to…
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
Adding together multiple COUNTIFS?
Hey everyone. I'm trying to implement a formula that will allow me to reference two ranges from one sheet and follow the specified criteria that is given to them. My most recent attempt; =COUNTIFS({Unit_Type}, "CP2 - Double", {ACCS Overall}, [T2]26) + COUNTIFS({Unit_Type}, "CP4 - Double", {ACCS Overall}, [T2]26) +…
-
I deleted my Predecessors column and now have no access to deleting any Predecessors relationships.
The docs say I can do this in the Gantt window, but I've found no specific instructions on how to do that, and haven't been able to intuit this process. Another solution would be to restore my Predecessors column. Inconveniently, copying and pasting columns between separate sheets "is not supported at this time." I imaging…
