-
Elapsed Days in Predecessor Field
Hi! Could you add the ability to enter in elapsed days (non-working days) into the predecessor field? This would be similar to the e#d in duration. Thank you!! Kind regards, Helena
-
Allow Manual Adjustment of Row Height
Excel has this functionality and it is invaluable for managing the display of data in sheets. Just because I have a lot of narrative information in a cell does not mean I want to have it all visible all the time when in the sheet. Often it is more valuable to see more rows than to see all the information in a cell at the…
-
Deeper AI Analytics
Can you make AI smart enough to compare multiple row attachments and create subtasks, summaries and/or compare and contrast information within said attachments? Similar to ClickUp Ai. Would like to be able to compare documents for similarities to uncover gaps for projects or create tasks based off of meeting transcripts…
-
Column Linking Not Working - What am I missing?
I'm the admin of a workspace which contains 2 sheets: 1) "Source Dropdown Sheet" which should function as master dropdown list to feed other sheets (sample a US State dropdown column), and 2) "Source Sheet 1" in which I'm attempting to link the State column to reduce copy/pasting. However, after going through the process…
-
Roll up features vs Snapshot features
New to Smartsheet, and getting acquainted with workspace someone else built. Why doesn't the "roll up" sheet have something that was entered on the corresponding form and Snapshot Report does?
-
When Predecessor Completes Mark next task to In Progress
I am struggling finding a formula to mark the successor task "In Progress" when predecessor is "Complete" like can be done in MPP. I am encouraging my organization to move to SS with the automation, reporting, dashboard and automation capabilities, and away from MPPP so trying to replicate some of the items they utilize in…
-
Product Usage Badges - Celebrating our Power Users 🎉
Are you an AWESOME Smartsheet user? We want to celebrate the power users of the Smartsheet product with special badges! Read on to learn more about them, and how you can qualify for each of them. These badges can't be requested. You'll receive an email letting you know that you've qualified, and we'll award them…
-
Trying to compare cells to update dates
Trying to find matching serial numbers, then use delivery date of the first entry to derive support date of 2nd entry. The below works for the initial entry but the Extension Order gets #Invalid Data Type error. Thank you in advance for your suggestions. =IF([Order Type]@row = "New HW", DATE(YEAR([Delivered Date]@row ) +…
-
Formula to calculate # of Projects per Month
So I keep getting #unparseable from my formula below. =COUNTIFS({Creative Marketing Request Tracker Range 5}[Start Date]:[Start Date], <=DATE(2025, 11, 30), [End Date]:[End Date], >=DATE(2025, 11, 1)) I have a lot of projects with different "Requested Delivery Date" (column header). Above I attempted to find how many…
-
Counting cells with two rules
Column with multiple drop down options (cities). Some submissions have one city specified, some multiple. Followed by four optional columns (Brand 1, Brand 2, Brand 3, Brand 4). Not all entries have four brand entries, some 1, some 2, etc. I would like to have a count of the number of brands (cells that are NOT blank) per…