-
Set Up Auto Notification
Is there a way to set up an automatic notification to send to an email address in a cell? When ive tried to set this up ive selected send to Contact but it only recognises the Created By field as a contact list.
-
Give Specific User Editing Access to a Locked Column
I am looking to give a specific user access to editing a locked column. The background: We have a list of projects that are NOT to be started until our finance director approves said project. As the project manger, I am owner of these sheets. To prevent other users from approving projects of their own will, I have locked…
-
Allow Multiple Contacts Per Cell
How do you uncheck allow multiple contacts per cell from the Assigned To Column Properties? The checkbox is marked and disabled. Having this checked has also limited the Card View where now I can no long view Cards by Assigned To
-
Updates on a ticketing system
Hello All, we are setting up a ticketing system to manage a medium (but growing number) of instruments. Unfortenately not all service requests can be handled in one visit. How can the "actions taken" column be updated lets say from zero to several times. In the best case each update corresponds to a service visit date. Any…
-
#Unparseable error
Hi I am new to Smartsheet, I am trying to calculate a row call Total Billable for each month of for our total amount of jobs completed. The format I'M using is as follows: - =SUM(Total Billable820:Total Billable828) it comes up with the error #Unparseable Can someone please advise me what I am doing wrong?
-
Graph scale question
Hello Smartsheet community!, I have a question. I built a dashboard with some graphs. Is there a way to change the scale percentage from 120% to 100%? See attached print screens. Thank you in advance for your help!
-
Embedding / Linking Images
Hi, I was wondering if there is a way to embed/link an image to present itself in the cell if that cell was to presented as 'true'. I want to be able to tick a checkbox and for the 'true' value to present an image. Thank you.
-
Counting party size from Symbols
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
Alert and Request for Update
Estou automatizando as etapas de solicitação e lembrete de atualização para atualizar minhas atividades. A planilha não está compartilhada, mas habilitei as permissões de alerta para as menos restritivas. A coluna do indicador de ações e alertas aparece no símbolo do lembrete e está em status pendente, mas não está…
-
Formula Text
I am using this formula and everything looks okay but the text that shows up for "Delivered Early" is showing up in the field as 0Delivered Early. I don't know why. =IF([Days Late / Early]3 > 0, "Delivered Late") + IF([Days Late / Early]3 = 0, "Delivered On Time") + IF([Days Late / Early]3 < 0, "Delivered Early")
