-
How to query data from one sheet to another?
I have a sheet which is essential reference data. I then have another sheet which will be used to actually do management with, but it needs to "pull" data from the reference sheet. VLOOKUP is only returning one data set. How do I use Smartsheet to query the reference sheet and return a list of rows which match a specific…
-
Carriage Return within a Cell - COUNTIF
I have read in other discussions that you can put in a carriage return to JOIN or COUNT through a work around by adding another column. I have tried this with a COUNTIF and I can't get it to work. My original formula had a comma between the results: ="Exceptional Performance = " + COUNTIF(Accessibility2:Accessibility6,…
-
Sheet summary formula to SUM a column where cells are formulas
In my sheet summary, I am trying to sum/total a column where the cell values are populated as a result of a formula. I can't seem to get a value. The formula for the cells I am trying to sum is this: =IF([Item Type]15 = "Stand Alone", "150", IF([Item Type]15 = "Unfolding", "450")) It is referring to one other column. I…
-
Can we create a report to find which sheets have proofs attached?
We have multiple project sheets and our team uses proofs within those sheets. I want to create a report to find out which sheets have proofs attached to them. Is it possible? If not report, is there any way using formulae that we can find out if the sheet has proof? For example, if the sheet has a proof attached, a…
-
Month from Week Number
The data source I have is only providing WeekNumber of a transaction, e.g. 1 - 52. Is there a way to convert that week number into the respective month number, 1 - 12? I can think of a painful nested if formula or an equally painful reference table as solutions. But can anyone think of an easier formula?
-
Formula Assistance
Good Morning Community, I was hoping that someone could validate the below IFAND formula as I am getting an error which I cant resolve: =IF(Status@row = "Green", "On-track"), ifand(Status@row="Yellow", "At-risk"), ifand (Status@row="Red", "Not on track"), if(Status@row="blue", "complete")))
-
COUNTIF Empty returns 10 extra lines
New to Smartsheet - Built a primary sheet, populated by form. 👍️ Now building a Metrics sheet to gather Status row counts to build a Database w/metric widgets. For some reason 10 extra rows are being added to my primary sheet when I use the COUNTIF formula on the Metrics sheet that references the Status column in my…
-
Formula for Status
Hello, I am trying to create a formula to automate the 'status' row in my project grid in SmartSheet. Here is what I am looking for: Actual start date = Blank, show "Not Started" If Actual Start Date = is a date and Actual end date = Blank, show "In Progress" If Actual start date = blank and projected start date > today OR…
-
Conditional Formatting
I have never had this issue but currently I have conditional formatting set to make a cell 'red' if the due date is in the past. The date is calculated based on a formula from other cells but this is a date column. The conditional formatting will not work. I have several dates in the past and none are following the…
-
Report Grouping Work Around
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retraining Record, are used for multiple SOPs. I tried: Using Gantt functions, added a Predecessor Column but I couldn't run a…