-
Extract Date from Date and Time in Date Column
I have data pulled into a date column in this format: 6/1/2022 7:30:57 AM This is not a system-generated field. I need the date only in another date column. Thanks for any help! Lori Flanigan
-
How to link a column to a different sheet that auto populates when new rows are added?
I'm trying to do a workaround to adding multiple rows from the same form. I created a new sheet that has columns for requests 1-10. I want to pull certain columns from that sheet to move to a new sheet and then I can use a workflow to transfer that to my main sheet. I've created an ID column that autogenerates a number as…
-
Question about Sum Function
Hi all - I met an interesting bug when using sum formula in Smartsheet. I used sum function to calculate the total of above 6 cells. It should show 6, not 2. Each cell except the last total is using formula to calculate sum of each row. I use "+" because feb-28 and Feb-29 are added temporarily. Only Feb 28 & Feb 29 columns…
-
MEDIAN formula picking up an extra row?
I have a sheet with a MEDIAN formula pointed to a column with a column formula to calculate the difference between two dates. Today the sheet happens to have only one row, but the result of the MEDIAN formula is that single value / 2. It looks like the median is picking up an extra, blank row. Any thoughts on how to…
-
Using cross sheet reference to pull data from one column in Sheet 1 into multiple rows in Sheet 2
I have two sheets. Sheet 1 is essentially a directory. It lists all of the individual contacts that are involved in a project. Some columns in the sheet are are "Name" (Contact List), "Title" (Text), "Department" (Text), and "Completed Assignments" (Text). Sheet 2 is where monthly assignments are recorded. The columns are…
-
Parent status based on children
This gets asked all the time and I've looked through posts but I can't get the formulas to work for my project. I have a project with hierarchy 1,2 and 3. I need the parents' status to update based on the children. My status options are: Not Started, In Progress, Complete and Blocked. If one child is in progress or…
-
Help with Formula Please
Hi, I am trying to find the formula so that the results show the total combined forecast amount but excludes any forecasted amount for an expected close date of 2025. Can anyone help please?
-
Week to Week % Complete Progress?
I have a % complete column in my project plan. Is there anyway to show progress on initiatives from week to week, for example, if we were at 30% last week and the report comes out and we’re now at 40% it shows in that box +10% or something?? I was thinking it will help show progress and if there is none, it could help show…
-
Formula to Pull out #s if they appear multiple times across different organizations
Hi, I'm trying to create a formula that will recognize and pull out any material #s that appear for different plants and make a new column with those material #s. I don't care so much if the material # appears multiple times for one plant, I only care if it appears for more than one plant. For example, Material # 1 appears…
-
Count IF Question - Running Count
Good Morning All, Currently have this column formula called "Count AD": =COUNTIF([Ad Name]$1:[Ad Name]@row, [Ad Name]@row) on lets say Sheet B I have the same formula on Sheet A: =COUNTIF([Creative Name]$1:[Creative Name]@row, [Creative Name]@row) Please Note: Sheet A Creative Name = Sheet B Ad Name Sheet B is generated…
