Hi, Please excuse my beginner's questions. We are starting to use scanning QR codes into smart sheet. Currently our QR code translates to the below text, where important values are delimited by "|" sy…
We have created a sum function in a row that has been copied down for 100 rows. We are only reading data from each row......not holding a cell from a previous row. When sorting and filtering throughou…
Hello, I need help. I am wondering how can I create a formula using the IF function with a range of dates. For example: If the date is between 01/01/2018 and 03/30/2018, then write 1st Quarter., and i…
I'm still pretty new to Smartsheet. My goal is collect data from another sheet in an easier to read format but I cannot get my COUNTIFS formula to work. If I do separate formulas for each criteria it …
Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to e…
I would like to write and IF formula in one column that involves 3 other columns. I'll do my best to explain what I am trying to do and the issue I am running in to. The first column is called "Buildi…
I understand that Smartsheet is not automation tool, but would like to make team's work easier without having to enter lots of information manually. Situation is that that we have two files: pipeline …
Every now and then, new form entries in my sheet will have some or all formulas missing. I add all new entries at the top of my sheets, so there are never any "blank" rows between that and the one bel…
Hi, I've noticed that when you insert a column in one of the source files all vlookups in other sheets will reference an incorrect cell. Either it should be smart enough to know the change on the sour…
In my sheet I would like the 'Status Level' column to autochange to 'Complete' when the checkbox for completed is checked off. Is there a formula to so this with?