-
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…
-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Counting Columns
Is there a formula that allows me to count the number of columns in a sheet (to include in a sheet summary/)
-
COUNTIF for Items in Dropdown Menu and Name From Another Column
I am trying to make a metric sheet to populate information for a dashboard. The originating sheet is from a survey/form. I would like to count how many times each category is paired with the Highest Level Person in Attendance column. For example, How many times the SVP is attending the Internal Audit Program topic?
-
On a sheet, can you have rows moved to the top?
We are using a sheet to track a project we are working on. I have set up conditional formatting so that when the project status changes to "Completed," the entire row greys out. Is there a way to move that row to the top of the sheet so that only outstanding items are displayed at the bottom? Currently, I have it filtered…
-
Formatting not staying the same for new form fills
I noticed that in my sheets the $ currency column formatting or the align formatting do not stay the same as the rest of the column for new form fills. For example, before if I inputted in 100 in the $ section it would go to the sheet as $100 and on certain columns they would be automatically centered but now they just…
-
Blank rows added after a new entry is created through form, why?
Why is it that it keeps occurring to me that when I get a new row of information (populated by a form) about 10 additional BLANK rows get instantly added on my main sheet? I have to keep deleting this manually and it's just adding a ton of manual work. Any explanations, solutions to this?
-
SmartSheet Automation and Sheet Update Delays
I've ran into an issue when trying to maintain a sheet. Triggered settings within automation to send out emails to assigned users have been receiving delayed emails anywhere from 1-2+ hours. Is there an explanation on what could be causing the delay? Initially there were about 40 automation flows setup to send to various…
-
Extracting text from a multi-select drop down column
I have an intake sheet where one of the fields is a multi-select drop down list. The values in the list are NUMBERS; TEST NAME. I want to be able to parse out just the number into a separate column in the intake sheet as someone submits it, so there'll be a populated column of Test Code Intake that has the NUMBERS; TEST…
-
Sheet automation loop
I am looking to understand how to break a loop so I can fix something. We are trying to remove columns from a sheet, but the automations keep replacing them on connected sheets before we can get them deleted on the other side. Is there a way to export a configuration so we can see all of the connected sheets? Also, how can…
