-
Compare two dates in the two cells.
Hi, I want to compare two dates, if the dates are different in the two cells I want them to glow red. What formula do I have to use and where to put it ?
-
Sumif Index Match multiple criteria
Hi, I would like to add the quantity in another sheet if they match 4 criteria in my sheet. For instance; I would like to add the quantity (from the Orders Sheet) of material ordered for each item in the Costing Sheet, to compare with what we costed on. Below is the Costing Sheet, so I would like to add up the quantities…
-
Assigning Contact Based on data in another sheet
Here's the rough scenario. I have 500 students who are divided up among 20+ teachers. When I choose a student in one column, I want to auto-assign their teacher in another column. I do this in Google Sheets with a formula, but wasn't sure how to go about it here. Let me know if you need more clarification. Thoughts? Gillian
-
COUNTIFS formula between a specific date range
Hello SmartSheet Community! I am trying to write a formula that will capture project deliverables status between a specific date range and I keep getting an error. I thought the below formula would work, but I am wrong, lol. Any ideas? =COUNTIFS(Status:Status, "Not Started", ([Start Date]:[Start Date], >=DATE(2022, 10, 1),…
-
Formula for Join, Collect, and If Statement - Resources Availability
I have a sheet that contains my resources' availability for each week and I'd like to pull in a list of those that have availability into another sheet so we know who to assigned to tasks on a project. I figured out the Join(Collect) part of the statement but I need to get the IF statement to work. Please see below for how…
-
Multi-select fields with INDEX/MATCH (or COLLECT) with multiple values
Hello fellow Smartsheet users! I am running into unique problem and more importantly finding the way to do something within Smartsheet. A little background. I build a request intake/workflow management tool for my Marketing department at a global organization. Users make Design, Content, Web, and Video requests through…
-
can forms have totals?
I want to add to a form a section that asks people for amounts and then totals it, is that possible? something like: blue widgets needed - # red widgets needed - # green widgets needed - # Total widgets = # blue+# red+# green
-
Formula for multiplying with rounding included
Okay, so I need to come up with a formula that does 2 things: Multiples the numbers in ColumnA with the numbers in ColumnB Rounds those numbers up or down depending on what the nearest .5% is For example: ColumnA has 6 in it ColumnB has 70% in it Multiplying those together, gives me 4.2. I need that to automatically round…
-
Input form for multiple sheets
I originally had an Excel worksheet with multiple tabs. The first tab was an input sheet which fed into 100's of formulas in the other tabs. The other tabs (one for each country) used the values from the input sheet to do the numerous calculations. In Smartsheet, I imported each tab (input sheet and each country). I also…
-
SUMIFS or SUM(COLLECT) With Cross-sheet Reference
I'm trying to total up hours from a timesheet for each individual across multiple projects. I've tried the following two formulas but both are returning 0. SUMIFS({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row) =SUM(COLLECT({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row,…
