-
filling columns -has to be a better way!
I have a schedule with close to 2000 lines. I am adding columns that need calculations in them. It currently takes me close to 15 min to either drag the formula down or copy and paste chunks. When I create the column why not provide me an option to enter the formula then and apply that to every row? Smartsheets has been…
-
Enhancement Request: Provide Highlight for differences using Data Validation
When setting data validation on a column (ie Dropdown type), a warning is provided to warn user there are differences. As an Admin, user can allow these. Provide some means to flag these differences. Moving to a validated column with 25 choices there may be dozens on typos or more in the old data. An easy way to find them…
-
Excel to Smartsheet WORKDAY formula
Here is my excel formula I use to find a FRIDAY shipping date. =WORKDAY($T1165,-10)-1+(WEEKDAY(WORKDAY($T1165,-10)-1)>=6)*7-WEEKDAY(WORKDAY($T1165,-10)-1)+6 I changed to this in Smartsheet but doesn't work. Any advice? =workday([start date]12,-10)-1+(weekday(workday([start date]12,-10)-1)>=6)*7-weekday(workday([start…
-
When are the LARGE and SMALL formulas coming?
Can we please get an update on these formulas? I was told quite a while ago that large and small formulas were being added, but 2 product updates have come and now I am not getting a response in the original thread about ETA's. https://community.smartsheet.com/discussion/formula-help-top-5-list-aka-large-formula#comments…
-
Sum hours from multiple sheets based on date ranges
I'm looking to determine how many hours are assigned to specific stage for a given week. Goal being I have "X" number of man hours available for a given week and if I've assigned 300% of that this week but 25% of it next week I need to know I've got shift resources or tasks around. I've got report that shows me all the…
-
Duplicating projects with cell linking
We set up our each project with individual department sheets that link to other department sheets. The issue we have is each new project, we replicate the prior project, but have to redo all cell links. What I'd like to be able to do is set up a template project that can be in total so that all the new sheets link to each…
-
2 Gantt Items: child rows and working backwards
Hello! I'm working on a sheet where I want to include sub-tasks via child rows, but the sub tasks do not all start at the same time, nor are they dependent on one another (and happen to be date dependent) but I need dependencies enabled for the sheet. I can't seem to figure out how to have these items start on a date other…
-
Workspace Reporting/Statistics/Administration
Hi, Is there a report that System Admins can run that shows how many workspaces we have and who owns them? I found where I can get this for sheets/reports but not workspaces. Thank you.
-
Linked cell skewing formula result
I am trying to write a formula that checks for 4 criteria; a. That the result in cell [Transition]38 = "Transition" b. That cell [NPS %]38 is not blank c. That cell [BG KPI]38 is not blank d. That cell [LE CM %]38 is not blank If all 4 criteria are met, then YES, otherwise NO. Of the cells referenced above, only [NPS %]38…
-
Displaying current user in Sights
Is there a way to display the current user's name in Sight. I am building a dashboard which needs to show the logged in user's name and data associated with that user. I can display the data using a report that filters data for the current user based on values in a column( of type contact list) but cannot use the same…