-
Hiding who is viewing a sheet
Hello! So I have been using Smartsheets for a short while and I think it's fantastic! I do have a query though - Is there a way of hiding who is viewing a sheet? We have a sheet with a massive amount of data on there which is shared with numerous suppliers we work with. They all require the data for different uses, some…
-
Revert to Single-User Contact Column from Multi-User Contact
Hello, Experimenting with the new Multi-User Contact Column, I've found out the hard way that it is treated as a separated Column Type. In other words, when running a report I need to have check 2 "Assigned To" columns. I went back to the Sheet that had the "Allow multiple contacts per cell" checkbox checked... and looks…
-
Conditions / Rule formula set-up
I am working on a sheet, and I am very new to this application, where I am tracking P.O.'s, date ordered, date received, etc... and I have 2 columns (at the far right of my sheet or end) that I would like to If the P.O. Total is < or = to the Invoiced Amount the cell would turn green and if it was > than to turn the cell…
-
Duration roll up values not displaying accurately
My duration roll ups for child/parents are not working as expected. Can anyone advise of things I could try to resolve why only one parent has a duration total?
-
titles and sub titles
I speak of Brazil, I need the lines to be numbered automatically, for example: 4 - General Projects, a subtitle 4.1 - Electrical Projects and another subtitle 4.1.1 - Terreo Pavement Project, can you do that? Annex follows example .. Att Gelson
-
Webform Error message - can anyone help?
Hello , We use smartsheet webforms for daily reports for some of our volunteer workers..this works fine when the forms are filled out on a computer, however when filled out in our school app and submitted, they get the attached error message saying "this form is not found". Despite this, we still receive the reports into…
-
Alerts & Reminders for "Assigned to"
Can you send reminders for upcoming due tasks to someone that is "Assigned to" a task? Currently I just send the automated reminders to shared users but, recently I had the need to just send particular tasks to selected individuals that would not be interested in the majority of the other tasks. I am thinking the answer is…
-
Count multiple criteria in a row
I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column. =COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of the…
-
Horizontal Axis Maximum Range
Does anyone know how to alter the horizontal axis range? I have a chart that is displaying percentages but the horizontal axis maximum percent is set to 120% so pieces of the project are looking as though they are not complete. I tried stretching the chart out and making it smaller, nothing works. In excel you usually have…
-
Where do replies to Update Requests to external parties go?
I've sent a series of Update Requests to external emails and I've had about 50% response rate. I have had someone check the validity of the remaining email addresses and we've found several of the email addresses are no longer valid (they don't exist) and several others are issuing Out of Office Notifications. When I have…
