-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
-
Sheet Formula_ Heath symbol
Hello everyone, I know I am close, but looking for some help. I am trying to create a formula to calculate If start date is less than today, health symbol is Green If start (maybe should be end date) is within (xx) days, health symbol turns yellow If start date (maybe should be end date) is greater than today, turns Red If…
-
Barcode Scanner Issue
I have been trying to get the Barcode Scanning to work for our inventory spreadsheet. I have the latest version of the Smartsheet on my iOS phone which is Version 5.1. Everytime I try to scan a bar code it just comes up with the number or the letters of the Bar code and not a picture of the Bar Code itself. I have followed…
-
One Approval for Multiple Lines/Whole Sheet
Hi everyone, I have stuck with this problem for a while and seen many questions about how to consolidate the approval requests to be sent in one email. It seems like the only solution so far is to create a report with a approval column that has checkboxes for approve, deny, etc. My concern with this way is that, in case…
-
COUNTIF with multiple select dropdown column
Hi, This has me going mad! 🤬🤣 I have a sheet reference "Business Area" which has a column type of dropdown multi-select. I'm then using a COUNTIF on specific values to compile a metric sheet. This is counting fine where the dropdown has "C" and "E" selected: =COUNTIF({Business Area}, @cell = "C" + CHAR(10) + "E") However,…
-
Data Migration/ Data Shuttle between 2 sheets
I have 2 sheets Sheet 1: Projects pending approval Sheet 2: All the projects that have been approved I want to build functionality where when I check an approved box in Sheet 1, it will automatically push to Sheet 2. There are a couple issues/ complexities. One of the biggest issue is that the Sheets have different column…
-
Reset auto number column
Hi All, I am not able to reset my auto number column recently. I followed the instruction at the bottom of the page:https://help.smartsheet.com/articles/1108408-auto-numbering-rows#create But it no longer works. I did it before, but not sure what changed. Thank you all for help Edward
-
Summary reporting with conditional formatting
Hello! I'm trying to build out a way to dynamically report on 58 state/territory sheets. Ideally, this report would have the total number of rows in the state sheet, plus the number of rows that meet two separate sets of conditions, with conditional formatting applied. I've tried doing this two ways: By using a sheet with…
-
Link to another sheet and conditionally output
Hello, I have one sheet that I am trying to link to and output data conditionally. There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with the LineItem record if the Department is "CF". Is there a function I can use to bring in this data? See…
