-
Formulas reading from ROW above.
Hello Community, Especially you @Paul Newcome the Formula Guru! I cant resolve this problem in the last 2 columns of this sheet. As you can see the Expected Cumulative Progress % is adding the Progress Weight + the value of itself from the row above…. any idea how to make this dynamic? Whenever new row is added / removed…
-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
Include attachment option no longer available?
This discussion was created from comments split from: How can I send an attachment from a line with an automation workflow to a recipient?.
-
Convert numbers to words
Hello, In an effort to automate our contracting process I am trying to convert numbers to words (preferably dollars and cents) for example $12,345.67 = Twelve Thousand Three Hundred Forty-Five Dollars and Sixty-Seven Cents. Using Google Doc/Smartsheet Merge I have completed most of the project with ease, however i am stuck…
-
Automation to Add Columns to Sheet Each Monday
Is there a way to set up an automatic function to copy a series of columns and paste them into the same sheet every Monday morning? We want to create a simple weekly schedule for our employees without going through the manual process of inserting rows before the previous week's schedule then duplicate the column titles.…
-
New regression : column names bein trimmed by the api
I've a sheets where the columns names are the following (without the quotes) : "Expiration Date " "Expiration Date " So, the first one has a space at the end and the second one hasn't. Previously that was supported by smartsheet API AND the user interface, although it's not possible anymore. What's funny : Most features on…
-
Automation bug
When we duplicate a sheet via “Save as New…”, some automation are being modified or part of them are being deleted. For example:Original automation not he original sheet. The same automation, but on after saving the sheet with “Save as New…” This is one example of many. You can see that some of the options I selected…
-
¿Como se modifica el nombre de la tarjeta de pago en los datos de facturación?
Necesito actualizar mis datos de facturación y sólo me permite cargar los datos de la nueva tarjeta pero encuentro donde cambiar el nombre de la tarjeta.
-
Desperate attempt to get help
Hello everyone, This is my desperate attempt to get help, since customer support is not even trying. We were trying to transfer the ownership of a sheet/workspace and we encountered error messages stating that it cannot be done. We tried a few times, and the error message says that if I cannot solve it, I should contact…
-
Why is my document generating with weird text?
My Smartsheet is generating a document with weird text, see below. This issue happens in both Microsoft edge and google chrome. Can anyone advise?