-
Report not letting me input data
I have created a report however i cannot seem to edit any of the data in the report sheet, they are not locked columns and are made so people can free type in one of the columns and in the other column they can choose from a dropdown menu... these work on the base sheet however I cannot input or choose anything on the…
-
Importing Excel Sheets with columns that have a Menu Selection
I have an excel sheet with imbedded menu options (Yes, No...etc multiple types of selections) in several columns, is there a way to import those menu items. I am only getting the basic cells, there are no formulas to import but critical that I get all these multiple menu items pulled in. Please advise and thanks.
-
Iterative Functionality (circular reference) in smartsheet.
I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built into automation tools. The specific situation is that I want to track how long a card…
-
Set up an alert when cell is blank after 3 business days
Hi! I need to set up an alert to notifiy a staff member and supervisor if contact is not made within three business days. I am using the Date Added cell and an Initial Contact cell. I want an alert to trigger when the Initial Contact cell is blank on the 4th business day from the Date Added cell. What formula should I use?
-
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…