-
Auto-Number on Certain Rows
Forgive my naivety as I'm still green at formatting. I'm trying to use the Auto-Number function in a column. I don't want all cells in the column to populate - only if column c isn't blank. I can't seem to get this to work where the auto-number will popular a cell if column c contains anything?
-
Need to transfer file ownership - Smartsheet won't let me!
Hello, I created a draft version of a workspace, now I need to transfer it to a licensed user and I get: "You have exceeded the maximum number of emails that your account can send" How can I get this fixed???? Thanks Karen
-
Forms
OUr forms are randomly requesting participants to complete a CAPTCHA request, however, we have not added this to our account and if it is going to show we want it to happen with every form submitted and not just random few. How do we correct this?
-
Send Update - To update only selected cell?
Is there any way to allow only selected cell for updates? Reason being that I would not want other data in the row to be accidently and wrongly updated. Thanks!
-
Date rollback
Hi All I'm having difficulty with my date formula's. i have a few in a sheet that i'm using to display today's date and a range of important dates as well as auto adding figures =SUMIF({Tokoroa orders}, TODAY(0), ({Tokoroa Orders out Range 1})) and =TODAY() my issue is that unless i manually go into the formula page all…
-
Regional Default Date format
Since the major outage earlier today (NZ time was not affected, thankfully) we have a VERY unstable date format, with frequent switches away from our regional default dd/mm/yy to the 'american' format of mm/dd/yy. The Smartsheet refresh icon makes no difference at all, but the Web refresh icon can fix it on one attempt,…
-
Smartsheets Down?
I am unable to access smartsheets from any of my devices. Is this just me or is anyone else also experiencing issues. Update: I found this link: https://status.smartsheet.com/
-
What happens to Workspace items, if existing owner is not with the company?
Hi, I have a quick question; although I do know about the System Admin capability that allows it to transfer the ownership of items to a new user via User Management option. But does it also transfer items which that user owned in a Workspace (not workspace but the items on it!)? If yes, then I am good :) If no, then what…
-
Formula to automatically check the checkbox in a "complete" column
I'm using RYGG balls to indicate the status of a row. Grey represents complete as a colour. When a cell is changed to grey in the status column, I'd like for the checkbox in the "complete" column to automatically be checked. What formula would I create to complete this task?
-
Sharing Multiple Sheets with a User at Once
Is it possible to share multpile sheets with a user at once? I have several sheets that I would like to make accessible to one of our users, and the only way I know of to do this currently is to go into each sheet and share one at a time. Is there a faster way to do this? Also, can I quickly view who is currently shared on…
