-
IF Function and Checkboxes
Hi, I am currently working on a project where I will have multiple check boxes on a row where each checkbox is going to of different values (true/false). I need a formula that will look over the checkboxes and only give me the value of the selected checkbox and then with this the value of that cell with be presented at the…
-
Toolbar Inconsistencies
I have created a "Master Sheet" that I have to import each day and have linked up other tabs/sheet to that Master Sheet to filter out on the information my technicians need to see. On the Master Sheet I have the full options on the toolbar, but on the linked tabs/sheet there are hardly any options. For example, my…
-
Conditional Weighted Averages
Hello, I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved. The column "Status" can also be Pending. The function SUMIFS works great if you don't need to do the weighted average. Is there a preset function or…
-
Summing up everyday new entry value into a different smart sheet
Hi, Can anyone give me some idea on Summing up across multiple smart sheets new entry value in separate smart sheet please. I can sum up specific cell values or range but i am looking for sum of daily entered values of same column from different sheets.
-
Formulas don't calculate when cell containing formula is linked
I have a sheet that totals the row values when a row is added from a form. It worked well until the cell containing the formula was linked using vlookup to a separate sheet that is the source of a dashboard. Now it will not calculate and the sheet that references the cell will not be displayed in the fo
-
Getting data OUT of Smartsheet into a form
I am wondering if and why Google seems to be the only way to get data onto a form for customer presentation? In my scenario, I am trying to get a few cels onto a customer view of a quote. I still want to use Smartsheet to perform the calculations and record of, I just need to send a customer a quote.
-
Join and Collect Function with Hyperlinks
Hello All, I got my function to work the way I wanted it to, but it did not keep the hyperlinks when it gave me the values. Is there a way to keep the hyperlinks or add them back when using Join(Collect())? =JOIN(COLLECT({Sandbox - DR - Deliverable}, {Child SKU}, =[Child SKU]1, {Sandbox - Delivery Readiness Tracker Range…
-
Dependencies for drop-down menus
Hello, How can I create a drop down menu dependent on value selected on the previous drop-down menu? Thanks Laura
-
Date Fields
I have two date type questions: Question 1 I am looking to auto populate a date field as soon as two other columns are populated. I want the date to remain fixed and not change to 'today' every time the spreadsheet if opened. The Columns Are: Date Part Fitted - this needs the date auto entered when: Part Number Fitted…
-
Cell linking effecting Last Modified date for whole sheet
I have a Main sheet with a cell that is linked to a log sheet to count total rows. whenever a form user adds a row to my log sheet it is updating the last modified date for all the rows on my main sheet. any idea how I can have this stop happening so I can send out a notification for any row that has not been updated in…
