-
Have there been updates to automation?
I've noticed recently that automation doesn't seem to be working... have there been any updates/changes recently? A basic workflow to update a cell value is not working: This workflow has been working without fail for nearly a year, and now all of a sudden, the cell value is not being updated. I cannot say how long this…
-
SUMIF and Absolute Value
Hello, I want to sum up the Project Remaining Hours of all "In Progress" projects. Sometimes I have negative project remaining hours, but I don't want to add the negative value. How do I sum up the absolute value of the Project Remaining Hours in the formula below? =SUMIFS({Project Remaining Hours}, {Project Status},…
-
dot and comma to separate dollar and cents
Some colleagues in US or other countries all over the world capture data via a form into Smartsheet. Sometimes cents are neeeded so the dot will be used to separate the dollar from the cent. My account is in Germany and the the Germans use the comma for separation not the dot. All data run into a failure and I have to…
-
Reviewing Update Request info for 3rd Parties.
I am developing a booking system for requests using Smartsheet that outputs update requests to 3rd party couriers to submit quotations for services. One of the couriers, who is consulting with me to ensure out output meets their business needs, has come back to me with a question about "the permanency of record" that i am…
-
Odd Formula errors
I have an automated request sheet that we've use for over a year. Example of a request from an entry on line 2: =VLOOKUP(Requestor2, {Contact Sheet Range 2}, 5, false) - it looks up the requestor (lrequestor from line 2/"requestor2), and cross references the "contact sheet" to find their supervisor (5) and then sends the…
-
Formula =COUNTIFS ... to not include certain text
Hey guys So i have this formula =COUNTIFS({Depots1}, [North(1)]23, {Product1}, FIND("Other", @cell) it counts the amount if = depot is North(whatever is inputted at North 23 column/ row) and Product1 Contains the word "Other" ... What I want to do is Count the amount of cells that depot is North, that the product column is…
-
Licensed user can not generate document from a template where it was created
Hello, hope you can help me. I created a project sheet with many rows, information and formulas which me and other licensed users use as a template to create new projects. Also i have created and saved pdf mapping on that sheet related to the information in some rows. Question: Why if I or other licensed users create a new…
-
Jira/Smartsheet Projects not syncing
Hi, My current projects are no longer syncing thru the JIRA connector. I get the below error message. Are there instructions to reconfigure the Webhooks as suggested here?
-
Can you create auto references in a sheet
I have tasks in a sheet and have a column "our reference" can you either put in conditional formatting or create a formula so that you as you add new rows to the sheet it will automatically populate the next number, in the reference column ie 1 2 3 4 5
-
Link Cell from Target sheet back to Source Sheet after Copied Row function
I created 2 sheet: Source and Target. I used the Copy Row function to copy the row from Source to Target once item was approved. All work. Now I need to be able to link the cell (from certain column) from Target back to Source (as Target cell may have updated data after copied the original data from Source in). Is there an…
