-
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…
-
Looking to count the number of times a string of specific text occurs in a column
I want to use a count formula to determine the number of times a SKU occurs in an open text column. Below is the formula for the highlighted cell: =COUNTIF(SKU:SKU, CONTAINS("SKU2", @cell)) The value I am looking for is 3 because SKU2 appears 2 times in the 3rd row and once in the 2nd row. Any insights on how to count…
-
Smartsheet Form - Latest entry is the only "actively" reported
Hi, I have a form for people to fill in that reports how ready they are for security. As this is evolving they can be expected to fill this in from time to time to measure how ready they are. So I only want the latest line from the form to be reported on. My system in place for this at the moment is to have a "Constant"…