-
COUNTIF and CONTAINS and OR
I have 2 columns that have multiple select drop down options. I want to create a formula that allows me to identify a PLO and then count the number of times "BE" OR "BC" OR "BL" or "BM" appear throughout the entire sheet. so: =COUNTIF([PLO Alignment]:[PLO Alignment], CONTAINS("A.1 Environment",@cell), Sections:Sections,…
-
Conditional Formatting Not Working
I use conditional formatting all the time. I have a new sheet that I can't get any rules to work. Can this feature be broken on a particular sheet; or can there be something hidden I'm not aware of?
-
What's wrong with my formula?
I know the answer has to be something simple, but I am just not finding the answer. If the Favorites column has a check mark, then populate (the cell containing the formula) with the Initiative Project Name. Maybe I'm not using the right function? 🤔 It seems logical to me, IF this row has a check, enter this data from the…
-
Combining If/then with date population
I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below) I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive". Any tips? I'm…
-
Status Colours - comparing dates
Hi Quite new to SS, but have been tasked with trying to update a current sheet to show a colour status column. I have 2 columns which hold dates, with some of the data been pulled in from other sheets, thats need comparing. If someone can help with the formula to show Green, amber, red status dots depending on the below…
-
How do I have a Dashboard show only 100% not 150%
Please see below example. I want to only show 100% as the top, not 150%. Is that something on the sheet itself that I need to do? If so, I only have a % Complete and % Remaining columns. What would i need to place in there to fix this.
-
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.