-
Making a Date Column N/A unless needed to for a specific row
I was wondering if there is a way to make a date column go N/A unless needed for a specific row or rows. For Example: I only want the Delivery Date Column to be active when it comes to Deliveries. Is there a way to do this or no? Please Help Thank You.
-
Finding a SmartSheet
I'm trying to find a SmartSheet, that I know exists, but isn't shared with me so I can ask the owner to share it. How do I find it?
-
IF AND trouble
I am trying to create a formula that assigns "Yes" to a cell if a result is within range and "No" if it is not. This formula worked for only one of the columns in the range: =IF([High Control Result]1 > [High Control Range Minimum]1, "Yes", "No") I tried to use AND without success: These formulas didn’t work =IF(AND([High…
-
SmarSheet Expiring for shared user and requiring subscription
Team! One of my clients is reluctant to use SmartSheets because she claims that when I share access and a certain amount of time has passed that she is required to purchase a subscription to SmartSheets. Is this true? I cannot find any documentation that supports this. Thanks.
-
Can't Print PDF of Gantt View
This project printed fine 2 weeks ago... now I can't print a PDF of the Gantt view. Grid view prints OK. Export to Excel and PNG work fine. It's not all that big... 67 lines. I've tried print entire sheet, selected rows, scaling or not scaling. Any ideas?
-
Is there a way to lock certain items in an update request
I am wondering if there is a way to lock people from editing in an update request certain fields or if I should not have them in the request at all? Please let me know.
-
Adding Time Values
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the week into a running yearly total. On my spreadsheet I have a Total YTD Hours Column, A column for each day of the week that…
-
Linking to another sheet when a certain word is used
I am trying to get 2 sheets to work together. Meaning when I have a certain word or phrase I would like it to link to another sheet. How ever it can only be that word or phrase or nothing else. I need help Thank You
-
Resizing an Image
Is there a way to resize an image that has been inserted into a Dashboard? I am able to increase the size of the Image Widget, but the image is still not large enough and does not fill the widget area. Need to know if I can manually resize the image
-
Increment dates for new year
I have an existing sheet which contains a schedule of annually recurring tasks. I saved a copy to create the new year's sheet and now need to update the dates. Is there an automated way to do this?