-
Can attachments be associated to specific cells?
...or at least can the sheet attachments be somehow linked to specific rows? I am managing the intake of new hire trainees and have a row for each new hire. In the sheet, I have all the training agendas for the classes; some of which are not taken by everyone, it's the classes are specific to the position for which they…
-
Generate Weekend Dates When Project Settings are Monday - Friday
@Kerlyn Mottershead I moved your question to a separate thread. Your question: I have a problem and hope you have a solution. My project duration days are weekdays only so I set my project settings as such. However, I do have a few tasks that only occur on weekends and my sheet is not calculating that in based on my…
-
Complex formula is calculating random cells and skipping others.
Hi everybody, So this will be a long read, but i hope somebody will help me solve this craziness, that already ate 2 days of my life. So i have this formula: =IFERROR(IF(VLOOKUP([Seller]1; {Range Seller | Bonus}; 2) = 1; IF(VLOOKUP([Sum]1; {Bonusai Range 1}; 2) < 1; [Sum]1 * VLOOKUP([Sum]1; {Bonusai Range 1}; 2);…
-
SumIF errors
I have a very simple formula in one of my sheets, eg: =SUMIF(Type251:Type271, "Service", Value251:Value271) and it works fine, the last row on the table is row 266. however if I extend the formula to =SUMIF(Type251:Type281, "Service", Value251:Value281) essentially just including more empty cells, I get an unparsable…
-
Averageif Formula
Hello All, I need your help to define a formula, I have Country column and Networkdays columns so I need to avg networkdays for the specific country. could you please help me. I am using : =AVERAGEIF({Table 1 Range 12}, {Table 1 Range 1}, ="France") But I am getting : Invalid operation so basically I am not able to give…
-
Automated Notifications
Can I change who a notification is coming from? We set up a form and the notifications are sent from "Shannon Heward via Smartsheet". Is there a way to make that generic? Please let me know. Thank you!
-
Automate RYGB Balls
I'm trying to automate RYGB balls by Date Needed [date] and Completed [checkbox] fields. Blue - Completed field is checked. Green - Up to 3 Days after Date Needed Yellow - 4-5 Days after Dated Needed Red - 6 Days after Date Needed Could you please assist? Thank you.
-
JOIN / COLLECT Formula Assistance?
Hello! I'm trying to setup a formula so that I can collect any names that are in columns "Worker #1 Name" through "Worker #10 Name".... and have them separated with a / However, there are other columns in the middle of these (see screenshot) and the formula that I setup seems to be capturing everything within these columns…
-
Index and Match or VLookup or both
I am trying to recreate this excel formula in smartsheet: =IF(ISNA(VLOOKUP(B2,'Participating Hotels'!$B:$B,2,FALSE)),"Not Available","Available") "B2" is the Property ID column on my sheet where the results will sit. So it will be ID@row Participating Hotels $B:$B is the base sheet column where all of the data sits. So…
-
Combing IF AND CONTAINS question
Hi, I have two sheets that I am working with. Both Sheets have a "Sales Order" Column. The Master Sheet has additional letters typed into the Sales Order Column, while the second sheet is missing those letters. The Master Sheet also has a checkbox. For the Second Sheet, I am trying to get this checkbox working as well,…