-
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…
-
Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…
-
Date Formula Issues, Metric sheet
I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well? I've tried a few…
-
Copying rows to new sheets based on multiple selections in one column
Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need! In my company we host CPD sessions where suppliers will come in for an hour over lunch and teach us something new. We need to keep a record of these sessions and who attended them. I have set up a sheet where I…
-
Help with a Sheet Summary Formula Error
I have a simple sheet summary formula that keeps returning "Invalid Operation". I am wanting to count the number of instances where the Potential Loss column is over $500. I've tried every variation of "500" I can think of (500.00, $500, "500.00"), but it's still returning an error. Any thoughts on what's wrong with my…