-
Data missing when moving rows?
Hi there, Has anyone noticed an issue with data missing when moving a row from one sheet to another? I have an automation that moves older rows in one sheet to an archive sheet once a month. However, it appears that data in at least one of the columns is missing. Any ideas what might cause this? Thanks! Jackie
-
Why is my sheet not showing up as a data source for a metric widget
Hello, I have two sheets in a workplace as show below. However, when I go to add a metrics widget to the dashboard only one sheet shows up as a potential data source. How do I get the other sheet to show up as a data source. As of now the metrics sheet is a column of descriptions, then a column of the calculations. The…
-
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…