-
2 or more projects sheet dependency
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…
-
Assigna mail adress automaticly
Hi there ; İ would like to get your advices about below issue , i have a column that i enter names ( colum name "Responsible") , near responsible column there is one column too (colum name "mail adresses" ) , is it possible that when i enter person name , mail adress will be written automaticly , these people that i add to…
-
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
