-
Defining a range using a variable as the row #
Hi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell? For example, rather than "15", something like =SUM([Column1]Row:[Column4]Row) where "Row" could be sourced from the…
-
Global Find and Replace for All Sheets in a Workspace/Find and Replace Column Name/Type for All Shee
Is there a way to perform a find and replace on all sheets in a workspace without loading each sheet? Is there a way to perform a find and replace for a column name or a column type for all sheets in a workspace?
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
Email Notification View
We use Smartsheet notifications and receive emails frequently letting us know that a task was completed, and it is now our turn to work on a task. We use MS Outlook as our email client, and within here I like to use the preview pane. When I receive the Smartsheet notification, I cannot see the task that is ready for me to…
-
Project Sheet nested checklist without duration and dependency
Hello Community, I would like to nest a short checklist of rows under an activity in a Project Sheet such that the nested rows representing the checklist do not require durations and dependencies. However, SmartSheet requires the duration and dependency on each nested row, where I repeat the same data, so it rolls up to…
-
Populating a sheet from a Webform
Is there any capabilities regarding populating multiple lines of a sheet from a web form? My company uses Smartsheet as an AP tool where vendors submit there invoices through the web form I created. My company has over 150 sites nationwide and over 300 globally, so some vendors we have are global as well and invoice 50-100…
-
Specification sheets
I need to send out a form with default values and a corresponding field for the person receiving the form to fill out. I do not want to receiving person to be able to see the sheet the form was created from. Once the receiving person fills out the field I want them to send it back to me so their entered data will stored in…
-
Links with Logic
I have two sheets that I want to share information across. Sheet1 contains hundreds of part number records and standard data fields required for each part number. Sheet2 contains essentially a task list of needs to be addressed each of the part numbers on Sheet1. The amount of tasks per part number is highly variable and…
-
OFFSET FUNCTION
Hi SC, Does Smartsheet have an equivalent of the EXCEL OFFSET FUNCTION ? Thanks
-
Link to cells in a different sheet
Hi SC, I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns. I tried it,…