-
2022 Core Product Certification Certificate?
I just completed the exam for the 2022 Core Product Certification and I can not find the certificate. They only thing I received was a badge. Where can I obtain the certificate with expiration date?
-
Nested IF, OR, AND with TODAY formula to return a symbol (RYGB) based on "Drop Down Menu Status"
Hi All, I'm trying to set a symbol (Red, Yellow, Green, Blue) in a column based on the individual values in one column. Here is what I have so far (but it is wrong): =IF([Current Status]@row = "Sarepta", "Green", IF(OR([Current Status]@row = "Thermo", [Current Status]@row = "Catalent"), "Yellow", IF(AND(TODAY()[Current…
-
Can I copy individual fields (within a column) to another sheet in particular order (Workflow)
Dear all, Can I copy individual fields (within a column) to another sheet in particular order triggered as Workflow process? I have a main sheet that is used to capture activities and statusses. Based on a specific status a part of the information (in specific order) will need to be copied to a new sheet to make it ready…
-
Request an Update Works Sporadically
I have a sheet where I have 18 different school site managers set to receive Request an Update emails when a new row with certain criteria is created. I essentially made one automation and then copied it 17 more times, changing the school name and the email recipient. The automation only works randomly and I can't figure…
-
Project sheets roll up into a Program sheet, with bi-directional syncing of worksheets.
I am looking to have sheets have a bi-directional sync between worksheets. Wanted it to be more of a Parent/Child relationship, where the Parent sheet can have 1 or more Child sheets roll up into it. While allowing the editing and syncing of each child sheet by both sheet editors. Scheduled or near real-time bi-directional…
-
User Permissions
Is there a way to hide an underlying sheet for a report? Our staff has to edit fields but I don't want them to see all the information in the underlying sheet. I created a report but they still go and access the sheet.
-
Forms - Send Auto generated number to requestor during form submission
Hi, I have created a form wherein have selected a column which is Auto number generated to create a New ticket # each time a row is added. Is there any possibility, that this ticket gets picked during "Send me a copy of my responses" At this time, it send only details as captured on the form but not this Auto Generated #…
-
Form Query String - Using Multiple Values
I've been doing some research on how to append values from a sheet, to a form link, so that when the user clicks on the link, certain fields are pre-populated. I've run into two issues that I'm looking for some help on: Can you add more than 2 values in the query string? I'm referencing fields in a sheet, so they're not…
-
Default value in Smartsheet Form will not save
I am trying to set a default value in a Form field and it will not save. I have tried both Edge and Chrome with the same result. The value provided in the drop-down are 0, 1 and 2. I want to set the default value to 0. In the past when I have experienced quirky issues like this I have recreated the sheet and that has…
-
AVERAGEIF formula with 2 sets of criteria
Hi! I was able to use the following formula to pull data based on 1 set of criteria. =AVERAGEIF({Range 1}, MONTH(@cell) = 7, {Range 2}) So, if range 1 includes data for the month of July, return the average of that data set in range 2. However, now I want to further segment by type of data. But my formula is not working.…