-
Support is not responding - Our form submissions are not working
Since Monday (6/14/2021) we have not been able to submit forms to our critical sheet. I have 3 cases with smartsheet and they have not responded. Does anyone have a more direct way to get in touch with support? Case number: 04735933 Case number: 04738520 Case number: 04741529
-
Continuously evolving Sum formula
Is it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul and Aug. The rest of the year is mapped in the exact same style, but for Sep Oct Nov and Dec.…
-
How to input a date/time and calculate a time elapsed?
I'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is =(Time1-Time2)*1440 which gives me a total time elapsed in minutes. I then build my dashboards to take those calculated fields and do…
-
How remove a character ">" in order to SUM values in one column if they meet a criteria.
I need to be able to get the results using a formula. (I can't use a helper column, or the find and replace to remove ">". Logic needed: This formula should substitute the greater-than sign with nothing and convert those to numbers. Then it will need to sum the numbers where the criteria is met (in this case the condition…
-
Smartsheet data connection in TIBCO Spotfire server
I am able to create an ODBC connection and get smartsheet data in my Spotfire Analyst client. I followed this link - https://smartsheet-platform.github.io/odbc-docs/#tibco-spotfire-desktop. However, I would like to create an information link and publish data in Spotfire library and share the web link with the users. The…
-
automate a download of a sheet
Dear Community: Please be gentle...I am new to the community. Our application uses forms to have people add row to various sheets. On one of the sheets we need to upload to one of 1000 systems as people continue to add to the sheets. I thought I could create a rule or action that would allow me to automatically download…
-
I need help so that I can calculate a percentage of completion
Guys, I need some help. I am struggling with calculating the percentage of completion of the whole sheet based on how many tasks are Complete in the Status column, or maybe better said to calculate the completion percentage based on the Parents Status in the Status column. Thank you and I am waiting for your advice.
-
*NEW: Proofing using Reports
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design requests via Reports so that they only see what tasks and designs are assigned to them.…
-
Is it possible to create an eSignature in a Smartsheet cell?
Is there a way to record or create an eSignature in a Smartsheet cell? I know DocuSign is integrated in the Generate Document builder, but besides that is there a way that a user can create an "eSignature" by typing their name into a specific cell that will translate it to or generate a cursive looking / more professional…
-
Formula to copy the information of one cell into a different cell
Is it possible to use a formula to copy the information of one cell ( In this case the cell is under a date type column) to another cell (also a date type column) . For example, if my cell #1 under column "concept start date" is: 06/19/19 then automatically my cell #1 under column "Start" would automatically fill up as…