-
Formula to display unique entries
I have a form that is tied to a source sheet and I have a separate data sheet where I am trying to obtain data on the list of cities. Is there a formula I can use to display the unique entries on a data sheet in column form based on what is input on the source sheet? Would this be sensitive to whether the cities are typed…
-
How do you get status counts by department?
In my project plan I have children rows that have different status. I've created another sheet/grid and trying to reference my main sheet and only pull in the count of status by department. I've reviewed other solutions but coming up 'unparseable'. I have the total counts of each status but need broken down by department.…
-
Formula ideas
So here goes; sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN} Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??
-
Roll-up multiple projects by "assigned to" and NOT TO BE A REPORT??
Hello beautiful community of SmartSheets, The client wants to use the card view of smartsheets but not in smartsheets itself but via Microsoft Teams, which is a great integration platform, the problem is that when you integrate a report via teams, is "View Only" so the client can't move the cards around or check tasks that…
-
Sheet Name renaming options
I am trying to add a shorten sheet name in a report. I have read it is not possible to add Vlookup to a report so am hoping for a workaround. Can I add the sheet name column to each sheet used in the report and then add the vlook-up column to the sheet and then add that column to the report? Is there another way to do…
-
Average Formula
Hello, I am trying to find the average number of days a person works on a specific type of file. In example: What is the average number of days it took Tom to complete type “A” files from the Intake Date to the RFA date? What is the average number of days it took Tom to complete type “B-Renewal” files from the Intake Date…
-
If cell A contains specific data, populate cell C with data from cell B
Hello Smartsheet Community! I hope that everyone is well and had a Happy Thanksgiving, for those of you in the States! I need some formula assistance for what I'm trying to accomplish. I have (3) columns: A - Veggie Type, B - Veggie Qty, C - Total Potato Qty If A - Veggie Type is "Potato", I want the C - Total Potato Qty…
-
Count Number of Cells that Contain Certain Text?
Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utilities]:[Utilities])), but it always turns back a 1 (no matter how many cells actually contain "ConEd"). I am trying to…
-
Making Parent Rows Display the Lowest status of their Children Rows
Hey everyone, I'm looking to have my parent rows simply display the lowest status of their children rows. My statuses are Complete, In Progress, Not Started. Pretty basic but I keep having hang ups for some reason. I don't know if it's because some of my children rows have children of their own to break up the task into…
-
I am trying to get latest date from a column
I have a column name Conditions having values A,B,C. There is also a column with created date in it. I am using this formulae =MAX(COLLECT({date}, {conditions}, "B")) It gives 0 when column type is text\number empty if column type is date
