-
Is there a way to have the grid view colors migrate to the calendar?
In the vacation planner template, the grid rows and the calendar rows are matched by color (the person's name in the calendar) for the first 4 rows+child rows. The calendar matches those colors. When I try to do this myself, the names/rows in the calendar are different colors or even the same light blue color. Is there a…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
how do you import an excel date/timestamp into smart sheet and have both date/time shown?
I captured date/timestamp in smart sheet 09/17/2020 13:35:44 and loaded this into smart sheet but the loaded value truncated the time, i.e, when loaded smart sheet showed 09/17/2020, but the time stamp was lost (truncated off). How can i also get the time stamp to be loaded, either in the same field or a departe field?
-
Can I do a conditional formatting based on values between two columns ?
I would like to do a conditional formatting on a column (column A) in such a way that if the value of "column A" is not equal to "column B" then the "column A" should be red. I dont see any options to compare values between two columns on conditional formatting. Your input is extremely appreciated.
-
COUNTIFS - Cross-sheet references, AND, DATE formula
I am trying to count the times a plant has entered on a specific date. (We have 14 plants - so...) I want to know how many times Birmingham entered data on 9/1/20. I can count BHM data entries;I can count the number of entries on 9/1. But I can't seem to put it together. =COUNTIF({Plant}, "Birmingham")…
-
Red Flag for overdue tasks
Hi, I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great. BUT.... It now red flags every row that doesn't have a date in yes which is an issue as we are using a project…
-
Date Range formula format
I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of January? Is this possible?
-
Can I hide rows using a condition?
Hello, Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format? If that is not possible, is there a formula that I can implement that would get the job done? I am managing a photography team and they have expressed the concern of seeing too much on their sheets that would…
-
Updating Date Column if Another Column has been Changed
I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date every time the sheet is opened and saved. I only want the Date cell to change when a specific other cell is changed.…
-
Return a sum using using sumifs and dates
My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting.. This formula returns a value, but I've checked manually, and I've determined the value is incorrect. I've exported a filtered view of the sheet,…