-
Sum of multiplication of two columns
Hello! I would like to get the year spend for new hires in a company based on their expected start date and percent time allocation. I have a sheet with multiple departments, salary budget, percent allocation for hires (i.e., 100%, 50%, etc), and expected start date. So what I would like to do is: For Department "X" and…
-
Converting text to Date to populate Gant & Calendar App.
I have an Allocation sheet where I need the user to choose the month in the "Month" column and the 'Start' populates with the first date of the month and the "End" populates with the last date of the month so I can have a start and finish date to show the resource and Allocation on a Gant and Calendar app. I have tried to…
-
Nested if helper column to set project size
Hi all, I am trying to create a nested if statement to set the project size to Small, Medium, or Large based on the estimated number of hours that project will take. This is what I have: =IF([Est Effort (Total Hrs)]@row = "30-120 (2-3 weeks)", "Small", IF([Est Effort (Total Hrs)@row = "120-320 (1-3 months)", "Medium",…
-
Looking for Formula where count of distinct PO #s in a given PO month
I'm looking for a formula, where need count of unique PO # falls in a month. In this formula, I used specefic PO # i.,e "123" but I need count of all PO # falls in a given month (See the screen shot attached) =COUNTIFS([PO Date]:[PO Date], IFERROR(MONTH(@cell), 0) = MONTH(Date12), [PO Date]:[PO Date], IFERROR(YEAR(@cell),…
-
Retrieving a date from another sheet
Hi All! Sometimes I think Smartsheet is too smart for me. I am simply trying to pull in a date from Sheet A to Sheet B...nothing fancy. I plan to link to a specific date field in Sheet A. I was trying to do Sheet References and I'm not sure what function I should be using. Can you help point me in the right direction?…
-
Network Days Remaining Until Due Date
With this formula for the "Days Remaining Until Due Date," it should be "0" when the due date is today and it should be "-1" when it is only one day past the due date. =IF(ISBLANK([Returned To]@row), NETWORKDAYS(TODAY(), [Date Due]@row), "Complete") Can someone let me how to fix it or if there is an inherent error built…
-
Make symbols turn Gray if date is in the past but only if that column had an entry
I have a selection of vehicles that have the below formula which will insert the red symbol if they are listed in the corresponding column: =IF([日付 Date]@row < TODAY(), "Gray", IF(CONTAINS("4号室 Room 4", [問題報告RV東照明 Reporting Issue RVE Lighting]:[問題報告RV東照明 Reporting Issue RVE Lighting]), "Red")) What I need to know is how to…
-
REPORT NOT ABLE TO VISUALIZE MORE THAN 2500 ROWS
Hi, I have this list of entries, (each one has his ID) stored in a sheet, some of them are validated, some not. I have this other report where all validated IDs are shown, grouped by certain column (country). Once i have arrived to more than 2500 entries the report states: Now the question is, please tell me i dont have to…
-
Sheet not getting updated properly even if linked properly
hello my friends, I have a Master summary sheet that get updated via control center every time a new project is created. This master summary takes data from multiple sheets. For some reason, the data is not formatted properly, or it is empty or it is written Lorem Ipsum even if the data is rightly linked to the sheet…
-
COUNTIFS(OR with multiple checkboxes
Hi, I have a formula where I am trying to say in column 1 count if checkbox A is checked OR in column 2 if checkbox B is checked. Here is the entire formula with the portion I cannot figure out in bold: =COUNTIFS(Simulation:Simulation, "Phillips ED", Complete:Complete, "0", Type:Type, OR(@cell = "Pilot", @cell =…