-
Graphs on Dashboard not updating dynamically
I have an issue with the charts on my dashboards not updating to show current metrics. Not sure if I am doing anything wrong but here is what I have done. 1 - Created a sheet and linked data from a Card that i have setup for my team 2 - Columns now show with Assigned to and status, I added a countif formula to count all…
-
Formula help
Hello, I am trying to do a vlookup on my smartsheet task list to reference a different smartsheet which looks up for example "312" returns the value two columns over, which is a date, and then minus 90 days from that date and returns that date in the cell. Is there a way to do this?
-
Nested IF and OR (and possibly AND)
Hello, I have two checkbox columns: one for Arabic and one for English. These columns will either be checked, unchecked or say "n/a". What I want is to have another checkbox column where it is checked if Arabic and English are both either checked or "n/a": for example: IF Arabic = 1 OR “n/a” AND IF English = 1 OR “n/a”,…
-
Beginner Formula Help - Extract Text from different cell
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 "|" symbol. When the below text is inserted in one cell, I'd like to create a formula that will extract the text after the…
-
row sorting is juggling formula
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 throughout the day, we are finding that the sum functions are trying to read previously held row designations. Row 10 may read the…
-
IF formula combined with dates
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 if the date is between 04/01/2018 and 06/30/2018, then 2nd. Quarter, etc.... Thank you in advance!
-
COUNTIFS / Referencing data another sheet
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 will work but not when I attempt to combine the formulas to look at 2 criteria's it fails. I have columns on the referencing…
-
IF Statement Limitations?
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 "Building" and this is where I am writing the IF formula. The second column is called "Work Center" and its a drop down list of 36…
-
Building a formula to connect multiple cells between sheets
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 and quote. Once the quote is completed, there is a series of Values, about 40, which need to be called up on the Pipeline…
-
vlookup - changes on source file
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 source and change it's formula or at least give us an indicator the reference changed so we can take actions to correct. Any way…
