-
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,…
-
Time Column
Hi , I was wondering if there is a function to have a time Column?
-
Can Smartsheet forecast end date base on % complete input
For example: Start Date: 10 Jan 2022 (Mon) End Date: 14 Jan 2022 (Fri) For simple calculation, working day duration is 5 days. Each day should achieve 20%. Today is 12 Jan 2022 and I should achieved 60%, but I only manage to complete 40%. Therefore I will need an additional one day to complete the task. So the forecast end…
-
Pulling multiple information from one sheet to another
Hi everyone! I need to calculate some information based on several criteria. I have a sheet called Quality and in it, there is a lot of information. but the columns i need is; Date, Product type, Good quality and total quantity. In the product type collums we have 3 different products, but we only need 2 for this…
-
Checkbox Formula Not Working
I am trying to write a formula that states If a value of a specific cell is equal to $0 then check a checkbox. I have written this formula and it is not working: =IF([Remaining Value by Customer]@row = "$0", 1, 0) The $0 in Remaining Value by Customer field has a formula in it to return the value so I am wondering if that…
