-
Stuck! Creating a Dashboard from a Sheet from a Report from Sheets. :/
Maybe I'm making this harder than it is but I can't figure out a way. I'm working towards ultimately building a Dashboard Chart (Pie Chart) based on Summary data from around 54 project schedules. I've created a Report that contains the information I need from the Summary information from each schedule (54 lines of summaryโฆ
-
How to extract data from Outlook
Hello, I'm hoping someone smarter than me might know of a possible solution to automate some data entry. I get emails in the following format and I have to manually enter the data into Smartsheet via form. But, I can get a lot of these throughout the month and I'm thinking there must be a way to extract this data fromโฆ
-
Assign Number to Duplicate Values
I have a sheet that tracks the phone number of our company cell phones and the allocation % breakdown for each phone for the appropriate budget codes that pay for that phone. For example, line 123-456-7890 has one row with 100% allocation. Line 098-765-4321 has three rows with allocation of 50%, 25% and 25%. I'm trying toโฆ
-
Formulas
I have a sheet created in which specific employees are awarded bonuses on. Those marked as completed would receive a bonus. So I need the formula for Status, assigned, Job # and address
-
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")
-
INDEX MATCH on multiple value cell
Hi, I have a column that can be filled from multiple items from dropdown list. On a second column, i'd like to return the matching items to those inserted in a first column. To achieve this, i have a second sheet with each individual item and it's match. Unfortunately when I try the index match formula, it only work whenโฆ
-
"Active Last Month" Calculation?
I have created a Calculation Sheet (feeding in to a Dashboard) with Columns including "Started Last Month?" and "Ended Last Month?". Row data therein is either "Yes", "No" (or "#INVALID DATA TYPE" - not worried about this at moment). I then have a further column, "Active Last Month?", which I want to report "Yes", "No" (orโฆ
-
AND/IF formulas
I'm trying to identify the syntax error in my formula. Can someone help me? =IF(Statut@row= "Terminรฉ", "Vert), IF(AND(Statut@row = "En Cours"; IF(รchรฉance@row<=TODAY(); "Rouge", "Jaune")))
-
calculating number of days
Need help trying to calculate number of days for my project so it will auto-update each time a row is added The idea is to calculate the difference in days between, in this example Date row 2 and row 1 in a different column (days). I was able to get it to work utilizing =NETDAYS(Date2,Date@row) formula however when I tryโฆ
-
Writing Quarter formula with different years
I am trying to write a quarter formula which includes quarter for the next year. For example, I would my results to return Q1 2023, Q2 2023, Q3 2023, Q4 2023, Q1 2024, etc. I am completely stumped. Has anyone done this before and if so, how did you make it work. TIA. Felicia