-
Help with RYGB Formula for Days past Start Date, Blue = Complete Status from Multi Select
Hello Smartsheets Friends, Using a Smartsheet for keeping track of Activation Status. Here is what I am hoping to achieve. 1-7 Days from Handover Date = Activation Call Status - Green 8-14 Days from Handover Date = Activation Call Status - Yellow 15+ Days from Handover Date = Activation Call Status - Red When customer…
-
Using CountIfs with several criteria including names, status, and date range
I've created a sheet to build metrics from a very large source sheet. I'm trying to count based on the following: the column {Module 3 - Section Owner} matches a cell in this metric sheet in the "Primary Column" a Date in the {End Date} that is between Today() and the next 7 days. I created three cells that determine what…
-
When can we expect an expanded color palette for Sheets?
Currently in Sheets for background fill and fonts, there is only the option of 5 shades of 8 basic colors as shown below. When can we expect this to be expanded to a full hex palette like for charts in Dashboards?
-
Request A Weekly Update Forces 50 Rows of Update. Only Need to Update First Row
HUGE issue. I have a workflow to request an update every Thursday. When workflow is triggered, instead of having only ONE row update, it asks for 50!!!!! This is bad. I tried to lock these rows but still is launching 50 pages worth of request update. ONLY ONE ROW should ever be requested. Period...
-
Match Numbers from one sheet to another
Hi I'm trying to make a inventory with a reference from a another smartsheet sheet, but since im kinda new into Smartsheet I dont know which formula I need to use. Its a hole Row from one sheet and then tell if it exist or not in the one that im working on.
-
Project Tracking that includes working day tasks and calendar day tasks
Hi All, I am attempting to manage a project that includes tracking tasks that follow our company's cultivation process in addition to production tasks. As most of us know, plants don't take the weekend off... Has anyone found a good workaround in project settings to account for this kind of project tracking variability? We…
-
What does the LOCK do in the summary sheet?
I have a formula in the field, I locked it but I can still edit the field.
-
trying to compile "other" comments from a survey
Hi! I am trying to compile survey data into a single page. The same survey will be used over and over and the data will keep adding to the data sheet. I have a few multi-select dropdown columns, which each have an "other" category that then opens up the "other" field in the survey if selected. Often, this is not used. I am…
-
Is it possible to get a count in Sheet Summary with the following equation?
=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0))) I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s) Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my…
-
Vertical Table header
Hallo SmartSheet Comunity, I miss the possibility to rotate vertically the Table headers. This should be an essential SmartSheet Feature.