-
Accurate Colors when creating proofs
We previously utilized Workfront for project management and proofing, and colors on pdf created where accurated, now colores, mostly blues are softer than real ones. Is this something Smartsheet can fix in your proof software, so we don't have to go through additional steps to upload each proof? Our team uploads numerous…
-
Automatic Deactivation of users
We wish to avoid manually managing our Smartsheet licence holders. It would be great, if we could set up an option to automatically remove or deactivate users that are inactive in our account after say 6 months.
-
Sum(Collect Calculation giving #Circular Reference Error
=SUM(COLLECT({Forecast Amount}, {Customer}, $Label@row, {Sales Stage}, Qualification$1)) That is the calculation I am using bring forecast sales based on Customer and Sales Stage into a metrics collection sheet. I am going out to the Sales Pipeline sheet for the information, two (2) sheet prints attached for reference.…
-
Automate 'Save as New'
Hello again, not entirely sure that this qualifies for the Basics. I have a template for new projects which I 'Save as New' when a Form is submitted. I then populate the major details by copying from the form. Is there a way to Automate this 'Save as New' process and populate the new sheet from the submitted form? I've got…
-
Update sheet with imported data and manually added rows/columns
Hi, I have a sheet with imported data from excel. I want to add sub rows. When I update the imported data, will the added sub rows delete? same for added columns. If I add columns to the imported data sheet, will the columns delete?
-
Re: Document Builder - Generate 1 PDF Document w/ Multiple Rows
I designed a weekly status report form using Adobe Pro, imported it into Smartsheet Document Builder by using Shift to select all rows then mapped the corresponding fields. How do I generate ONE PDF document containing all my mapped fields per row instead of getting it to spit out multiple PDF's? I also see duplication of…
-
Como gerenciar e classificar registros de data e hora no Smartsheet
Esta postagem de solução foi criada com base em um guia de práticas recomendadas originalmente desenvolvido por @Kelly Moore . Você pode encontrar a postagem original aqui: Converting a Text Timestamp into a Numeric Timestamp Value. Problema: quando os registros de data e hora são importados para o Smartsheet, eles…
-
IF formula help resquested !
I'm trying to to create a formula that turns in a number the text in a row. this formlu is working : =IF(FREQUENCE@row = "Probable FREQUENT"; 5) but when I try to add other text it just doesn't work. I would like to create a formula that gives me these numbers in these conditions : Probable FREQUENT = 5 Probable MENSUEL =…
-
I have earned the Smartsheet Automagician Badge but I am not able to claim it
I have earned the Smartsheet Automagician Badge but I am not able to claim it.
-
Formula to mark the checkbox for the newest date in a row
I have two columns in a form: Current Status and Date of Completion. The Date of Completion column should be updated on a weekly basis. I want the Current Status to check off based on the latest Date of Completion. Is there a formula to do this?