-
FIRST OF THE MONTH AFTER 60 DAYS
I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date) I need to have the following result as an example Start date: 1/15/2020 Effective Date: 4/1/2020 Thanks!
-
Custom Report Format Possible?
I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way. For instance if I have the columns and 3 rows. * Publish Date * Category * Title * Body Text…
-
GLITCH? Text isn't wrapping nor doing a copy/paste correctly
Good morning, I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text. Thus, it makes copying the text and pasting it wonky. I often have to copy/paste text from SS into Word. It pastes with embedded formatting that I…
-
How to Sum Cells with Numbers & Text
Have a super basic question I just can't seem to find a quick answer for. Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell with the following formula: =15 + " min" Result: 15 min When I add 2 cells with that formula [=15 + " min"] + [=15 + "…
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Calendar View & Booking
Hi - our company is looking to hire out a hospitality box in London for a 12-month period that hosts events all year round. We would like internal employees to be able to view the event calendar and to book slots for a specific date where they can then invite their own external customers as well as internal guests. In…
-
Copying/Moving attachments to other rows
Good afternoon, I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements. In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the only way I see to do it is to download the attachment and then upload to the new row (it's…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
-
Automating Day of the Week Lanes in Card view
Hi all, We're using Smartsheet to plan content development and scheduling for a radio station. We'd like to create lanes in the Card View for each day of the week (I already know how to do that part). But each row in grid view already has a broadcast date assigned to it, which of course feeds the Calendar view. I'd like to…
-
Priorities within Priority
I have my priorities set up for high, medium, low. I'd like to prioritize within the highs, lows, etc. I'm used to working of an ABC, 123 set up.
