-
Sorting Unlocked Rows or banging my head against the keyboard!
i have a a sheet. no columns are locked. I have a "Date Changes Made" column that i wish to sort in date order example every entry from 7/1, 7/2,7/ 3 etc so that I can have all dates of the current month together. My list is a running list so it contains dates from April-July so far. When I have used the Sort rows…
-
SUMIFS to Calculate Values for a Specific Year/Date Range
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date range. I have searched the community questions, and I haven't been successful in finding…
-
Numeric Values from form unexpectedly converting to currency
Hi, I have had a sheet with form I've been using for a few years now. Just in the last month, a couple of the columns have been displaying data incorrectly. I have customer numbers that can contain a prefix of $. These are now converting to currency format. So customer $3131231 is showing up as $3,131,231. I also have…
-
multiple IF OR statement help
Hi Can get one IF OR statement but need help with multiples please... =IF(OR(Name2 = "Alex", Name2 = "Dana",Name2="PAt"), "Jo" OR (Name2="Adi", Name2="Mal",Name2="Mark "), "Angela" OR(Name2="Sophie", Name2="Amy", Name2="Elle",Name2="Dan"), "Mary") THANK YOU!
-
How do you apply the same conditional formating to multiple cells?
In excel I can create a formula in a cell, then create conditional formatting on that cell. For example, I can do a quick formula to compare to values. If the value is <0 apply a format that makes the cell red. I can then cut and paste that cell into any other cell I want in a spreadsheet and it gets the formula and the…
-
Can a read-only account export data
We are losing our account data at the end of this week, and will move to a read only account for 30 days. Does anyone know if we have a read only account if we can still export the Project data to Excel and such like, or once read-only you cannot do anything?
-
Reporting
Newbie question so please bear with me! As previously discussed, we use 3 columns to calculate the % Complete (which we then have to manually enter into the standard '% Complete' column), which are: Planned Effort Actual Effort Remaining Effort What I need to be able to do is to create a Summary Report based on the three…
-
Form is not populating to Smartsheet - Help!
Hi there, Created a Form and tested successfully last week, data entered into Form after submission populated properly to Smartsheet. This week, 'live', form info when submitted is not (making it to) populating data to Smartsheet. Any idea why this is happening? Thanks!
-
3 Conditions Formula
I want to have a flag turn red if 1. A task is considered a milestone, 2. The Planned End Date is today or before, and 3. The task is not done. The below formula is not working: =-IF(AND([Is Milestone]@row, 1, Done@row, 0, [Planned End Date]@row < TODAY()), 1, 0)
-
Gantt chart that overlays multiple projects
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a way to accomplish this?
