-
Bug: Please Fix Auto-fill (blank rows)
Please fix the auto-fill bug. If I add a row to sheets via Forms, Zapier, or other automated tool, SOMETIMES there is a gap between the last good row and the new row. SOMETIMES this is single row, sometimes as many as ten rows. This causes auto-fill formulas to break. The result of this is hours of time by either me or my…
-
Merged: Partial formatting of the cell contents - Bold/Italic
This discussion has been merged.
-
Using a formula to count numbers of projects assigned to an employee and at what stage its at.
Hello! I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level. I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get…
-
Updating Smartsheet from external sources
I have a task list (for want of a better term) that was made in SharePoint and shared with many users. They make updates. I then export to Excel, import to Smartsheet and do what I need to to make an informative report. I can't remove the SharePoint element from this process. I need a way to update some of my information…
-
IF and TODAY
Hi, I have the below formula which is working correctly: =IF([Item Name]@row <> "", IF(ISBLANK([Actual Sign Off Date]@row), "TBC", IF(AND([Actual Sign Off Date]@row <= [Sign Off Required Date]@row), "ON TRACK", IF(AND([Actual Sign Off Date]@row > [Sign Off Required Date]@row), "DELAYED")))) I have another formula which is…
-
Trying to count total dates in a column for a specific date range
I'm trying to count the number of submissions of a specific activity in a specific time period. For example, I want to count the number of submissions for Task A in (Task A/B column) that were submitted in the period >=3/6/23 to <3/14/23 in (Submission Date Column). I have filtered the file manually and the correct number…
-
Can a duration column with dependencies not pull data from a created date column?
I have a sheet with a created date that is generated by the system upon submission of the project. I wanted to create a column that tracks the duration of the project from submission to delivery with dependencies, but when I click the drop-down under project settings it doesn't have that created date listed. Is there a way…
-
Ability to change default background color and background color in sheets
I think the ability to change the background color in smartsheet would be very beneficial in helping avoid eye strain. Most of us are looking at white screens all day and our eyes get very tired and strained. Even with special blue blocker glasses I still notice the eye fatigue. Please consider adding this feature in a…
-
Brandfolder + Smartsheet automations
I would like to send files to Brandfolder via Automation. In this automation, I want to be able to select Tags, Selections, LABELS, etc. Most important I want to ensure I can select which collection it goes to. User: would be Smartsheet automation.
-
Merging Data
Combining Rows and merging their content would be very useful.
