-
Determine Scheduled Hours between dates for Team members
I am trying to create a reference sheet for a dashboard. For some reason I am super stuck. Basically, I am trying to determine the number of hours each team member has scheduled for their projects during the week. I am using the below formula. My columns are Hours, Start Date and Team Member =SUMIFS({Hours}, [Team…
-
Excel Sheets as the base content for Dashboards
Hi- I have team members that are very resistant to anything new. They want to continue to use Excel for their spreadsheets and wonder if the Dashboard and other sheets that folks use in Smartsheets can actively link to their Excel sheets instead of actually having a SmartSheet. I know that Tableau does this - it links to…
-
Conditional Formatting Kanban apply on newly added row
Hi all - I have conditional formatting for our kanban view for the task bar color of our cards to mirror our health status field for our project tracker. It seems to be working well once a card is built and the health field changes. However, when a row/card is added to the sheet new, the conditional formatting rule does…
-
Why is my multiplication formula invalid?
I am trying to create a column that multiplies the total hours by the pay rate of certain staff. In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", IF(Name1 = "Stephen", "55"))) This formula works well, however if I then try to use those values in another formula is just…
-
Using COUNTIFS to count specific words
I have a sheet with a multi-select containing topics such as: Age, Disability, Wage-Hour, Sex, Sexual Harassment, Sexual Orientation, and other unique values. I am using this formula: =COUNTIFS({Drop1}, CONTAINS(Claim@row, @cell), {Month}, 1) to count specific instances by month and it works except for Age and Sex because…
-
Summing cells with text and checkbox
Hello, I am looking for a formula to add cells that include both text and a checkbox. Please see example below. If Request Type is "FSA" and the box under "Backlog" is checked, formula return a "1". Similarly, if Request Type is "Warranty" and the box under "Backlog" is checked, the formula returns a "1". Thanks again for…
-
Formula to Cut and paste Last 5 Digits into another cell
Hi there, Is there a way to Cut and paste Last 5 Digits into another cell? Example A1 has: 12345678, can I cut 45678 and paste into B1, using the same formula, for the entire column ? (I know about the remove first or last digits, but is there a way to cut and paste?) Thank you for your help!
-
Display negative for past days and positive for upcoming days
I've got a sheet with a "Start" column and a "Today" column. I want this formula; =NETDAYS(Start25, TODAY25) To display the number of days as a negative if the Start was prior to TODAY or as a positive if the Start is after TODAY. Currently, my displayed results are opposite to that.
-
IF/OR Statement
Good morning everyone, first of all, thank you to this community, you have all been a huge help, as someone who had very limited excel/smartsheet skills, this community has helped a lot! My organization has several departments and in our office one individual is responsible per department. Although long, my formula looks…
-
If/And/Or formula help, please!
Hi there, I've been playing around with an if/and/or formula but I can't get it to work. Can someone please review my formula and tell me what I'm doing wrong? What the formula should do is to indicate "Yes" if status of row X and row Y is any combination of "Yes" or "N/A". If there is a "No" in any either of those rows,…
