Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
BUG: DAY() against the Created column sometimes returns wrong day
When using the DAY() function on the system generated Created column, a time zone issue surfaces in late hours. For the Eastern Time Zone, DAY(Created N) sometimes returns the next day. For example =DAY(Created1) where Created1 = "05/17/17 10:32 PM" returns 18. See snapshot. Please advise. Thank you.
formula in all 5000 rows
can i add a formula in one column in all 5000 rows? we have tried but sheet doesn't seem to allow us to add the formula too far beyond the last row of data. any help please?
Linking checkbox to another column
We have a checkbox in our sheet titled "Use Existing". When that box is checked we would like for another column to be added so the person can provide that existing information. If the box is not marked then we don't want that extra column to appear. Is there a way to make this happen? Not sure if there is a formula for…
max Rows that can be sent.
I have a bit of an issue . I have filtered a section of my sheet it has 75 row . I select it and click send . the customer however recieved 50 . Is there a limit to the send functionality . could use some help
Smartsheet Maps
Are these working for anyone? Seem to be down.
answers to comments sent by mail
hi there a maybe simple question: I sent comments with mail. The email adress of sender in this mail is user@xxx.at - not mine. How can i change this? thx Peter
Sum(children()) with filter or in reports
Hi there, is it possible to get the sum or count of a filtered sheet or in a report? I want to know how many lines are filled with data. I use the count(children()) function. In one cell are the nicks of the employees (like "KOV, SEA, KEP ..."). Now I set a filter that only shows me lines where "KEP" is in this string. In…
Problems with Data Erasing or Disconnecting in Smartsheet
Is anyone else experiencing problems with content and data such as formulas suddenly disappearing and you find yourself adding the formulas back to your designated fields even though your saved after all of your changes and everything is working fine? This is the second time I have noticed this has happened. Which is…
Sights - How to
Hi! I am learning how to use Sights and experimenting on how I need to organize my data in the right way to make Sights work. What tutorial/webinar/video have you found MOST useful in getting started? I'm hoping to find a link that has the best tips and tricks. Thank you all!
Order of columns to select when sending email
When I want to email someone, I don't want all the columns sent in the email. I click on the edit columns to select what I want to send. Many times it's just one or two columns that I want to send. However, it is very difficult sometimes because we have a sheet that contains many columns. The order of the columns seems…
