-
New row autofill
I want to autofill new rows with formulas that would execute as data is loaded into certain fields. Specifically, someone uses a form to start a new row. In the form there is a logic option but not a real conditional with a formula. It may not be available in the Form but what about the Sheet? There is languaging about two…
-
Reference column in multiple sheets to look up information
Hi! I've been researching this for quite a while, but it seems I can't find a solution on my own. Hopefully, some of you have encountered the same type of issue, and will be able to point me in the right direction. I'm trying to create multiple sheets to help my team keep track on our projects, and have created a…
-
Formula based on System-Generated Created Time
Is there are formula to bring the time out of the the System-Generated Created Time to e.g. add on 20 min to this and then perform an action? I have an easy sheet which is filled via 2 forms; one form is used to check in, one is for the check out, filling the same sheet. Problem statement: If someone forgot to check out,…
-
Stacked Bar/Column Charts and Opening Smartsheet Item(s)
I have a couple of Stacked Bar/Column Charts and would like to open a Smartsheet item when selecting a Segment of each Bar. Is there a way to achieve this, or do the Graph Widgets [currently] only support 1 item to be opened? Thoughts on a work around?
-
Cells with IF functions somehow linked
I have 2 columns on sheet A, each with a large IF statement. They both look to fields on sheet B (the same sheet but different fields). For some reason if on field updates, it updates the other field. They are not linked or copied in any way. I've manually rewritten each IF statement more than once. No matter what I change…
-
Why is it that when I drag a formula the information I am looking for is not preserved?
Esta es mi función: =COUNTIFS({LAYOUT CHECK FOR DAL Rango 2}, $Date$1, {LAYOUT CHECK FOR DAL Range 5}, "DAL 2", {LAYOUT CHECK FOR DAL Range 6}, "No") Si la arrastro en otros ´10 ítems hacia abajo, se pierde la secuencia lógica, lo subrayado en gris es la columna "Rango" que no respeta Cuando actualizo referencia hace como…
-
Computed/Automatic Population of Date?
Hi Everyone! Is there any way to get a date automatically in a cell when a certain cell in a column changes? Not using the System-Generated property because I do not want the date to change when ANY column changes only one. Thank you :) -Jenna
-
Formula for dividing 2 columns then multiply by 12
I am trying to get the average for a specific category (Column 1), by dividing YTD Terms (Column 2) by YTD Headcount (Column 3) then multiply by 12 for my Column 1? Here is the formula I am trying and I get Unparseable. =COUNTIFS({Turnover ratio by Dept July 2020_YTD Term}, /{Turnover ratio by Dept July 2020_Average…
-
COUNTIF Only if System Generated Date Column is Current Year
I am trying to create a formula in a Sheet Summary field that displays the total number of rows I have in the sheet that were created in the CURRENT YEAR. I have a system-generated date column - the column is titled "Created". The only criteria is that the Created column has a date and that the date is in the current year.…
-
More options for RAG Status
Hi, We have a requirement for additional Status options than Red, Amber, Green - I also need Blue to mark complete and Grey for not applicable. Currently, I have to choose either Blue or Grey - just wondered if this came up as a requirement for anyone else and what did you do? I still want to see the circles - so, adding…
