-
Stumped on a formula for a parent cell to aggregate names of the subtasks.
I'd like to capture the Individual Project names, tracked by subtasks, and aggregate them in the Parent Cell (All Project Names). This way, when minimized, I don't have to expand to see which Sites the task is for. Also for Dashboard views, to see which Sites are part of the parent project that is being tracked. Screenshot…
-
Form Submitted but never shows up in the sheet
We had a customer submit a form on May 12, 2023 that never populated in our sheet but the submitter received a copy of data they submitted. We've reviewed the history and don't see anything on May 12. We've combed through things carefully and can't find a reason, which is unsettling. How likely is this an issue on our end…
-
Formula to return the first day of the month for the prior 13 months?
I'm building a rolling 13 month graph and I need a formula that will take today's date and provide me with the first day of the prior month, first day of 2 months ago, first day of 3 months ago, etc. so that I can then do a lookup from my master sheet to pull the right data from those respective months. The formula would…
-
Converting =SUMPRODUCT from Excel to Smartsheet
How would I convert this formula to work in Smartsheet? =SUMPRODUCT(($B$93:$B$137=$A144)*(J$93:J$137)*(1-($G$93:$G$137))) B93-B137 = Project Type J93-J137 = [July thru 7/31]$125 I can get the first part using a SUMIF formula: =SUMIF([Project Type]$83:[Project Type]$125, =$[Project Type]@row, [July thru 7/31]$83:[July thru…
-
Next asset tag value formula
I'm using Smartsheet as an inventory management system which is working very well. Is there a formula that I can use in the sheet summary to search the values in a column to find the max value? This should give me the last asset tag number used. I am using =MAX([ASSET TAG]:[ASSET TAG]) but it's giving me a 0. We do have a…
-
Automated update after an automated report has already sent
Hi Community, I have set up some automations for my PM team where every Thursday, each one of them receives an update request to give a weekly status update on their projects. When they submit their updates, it populates to specific columns on a master Smartsheet depending on date of submission. This sheet stores all…
-
Health Bubble Turn Colors when Status is Updated
Hello, I am new to Smartsheet. I am trying to get when I change my Status to "Not Started" I want the Health bubble to automatically turn grey. And when I change my Status to "In Progress" the Health bubble will turn yellow, etc. So far I have: IF(Status1 = "Not Started", "Gray", " "). I want it to change color for each…
-
Need some users to have the ability to update certain columns
Hi, We are using a Smartsheet to track order progress from start to finish. The sheet has many columns but we have 8 dropdown columns that indicate completion in certain departments...Department A, Department B...etc. How can i grant access to the leaders of each department yet protect the rest of the columns that do not…
-
How do I create and If Formula pulling from another sheet to designate indicators?
Good Morning All, I am working on a Overall Health for a Project that looks like this: I need to update the lights by using an if statement looking at three different columns of another sheet that are not next to one another on the sheet, example of that sheet below In the first sheet for each Column I need to look at the…
-
Help creating formula to update inventory automatically
The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…