-
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…
-
Count distinct values in a column if it falls within a date range
I am trying to run a formula in one sheet (let's call it sheet 1) to return a count of distinct values in an entire column of a different sheet (sheet 2) only if the corresponding date (also in sheet 2) falls within a date range. Sheet 1: Column [Site Receiving Transfer] is the column I would like to count the distinct…
-
Cross Sheet Reference If Cell is Not Blank
Hello - I'm trying to produce a Y/N output based on whether a cell from another sheet is not blank. If the cell in the other sheet is not blank, I want to produce a "Y", if it is, I want to produce a "N". This is the formula I put, but I'm getting an #INCORRECTARGUMENT. What am I missing here? =IF({CPR Expiration}, <>"",…
-
Why is my Automation moved the whole sheet rather than just completed
Why is my Automation moved the whole sheet rather than just completed
-
Count how many per Month and Year for Summary Sheet?
Hey - I'm trying to create a summary sheet for photo data. I want to count how many Photo shoots are happening per month/year. The screenshot is below is our "Comp" sheet that has the data I want to pull for the summary sheet. So ideally, I can then create a graph for a dashboard. The AI generated this formula:…
-
Formula to summarize orders of 1-10 products within 1 column using info from other columns
"Trying to create a summary column that lists (on a separate line) the 'order' for shipping of 1 to 10 items. Ideally, if 10 items, it lists all ten (item description,# & units) on a separate line if 10 items are requested, if only 1 requested, then it only lists 1. I have done an If nested statement that worked but when I…
-
Smartsheet workflow not sending email notification
Hello Smartsheet Community, It seems like I have a problem that others have had in the past: neither I nor anyone else is receiving email notifications from Smartsheet workflow automations that I created. If they have an account, everyone is receiving notifications within Smartsheet, but not via email. The automation is…
-
Incorrect Argument
I am having problems with this formula This is a reservation system for multiple locations. Each location has a different number of space available. I am trying to write a formula that will calculate the current number of spaces available based on the number of different bookings and give you a most current updated spaces…
-
Auto-Number Based on Parent Child Relationship + Move Rows in Work Breakdown Structure
Hello Community, My company is trying to use a sheet to track all open eMarketing efforts each with a series of sub-tasks. I found a great solution within this community and is based on this: https://www.smartsheet.com/marketplace/templates/work-breakdown-structure-wbs , where I can have an ID for any added new row with a…
-
% Complete column not computing
My project row «SCC Project Name» is the parent row (hierarchy level 1). The phases under it are indented as child rows (hierarchy level 2). Phases= Initiating, planning, executing, closing. The % complete is not computing on the main project row (22). It also will not allow me to enter a formula. They are not locked…
