-
Reference the value of an active cell?
Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencing each cell in a range. Example: Project1 will start in 2018, which is reflected on sheet 2. formula in column 2 row 2 on…
-
BUG?! - Inconsistent Date Format (US/UK)
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…
-
More Robust and Complete Backup Solution
Hi there, Are there plans to offer a more robust backup solution for sheets? We are using the Command-line backup java utility (aka Backup Tool), and that works alright, but it’s not a true backup solution, as files cannot always be simply re-loaded back into Smartsheet have things be “just the way they were” when data…
-
Linking to external location
Is there way to provide hyperlink of any cell to local drive on the machine likewise in Excel we have that facility ?
-
Cell Text in Form Title/Description
Is it possible to pull values from a sheet into a form? See screen shot for more information. Thank you
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Problems with Cell Linking working on some cells but not others
I help develop Smartsheet sheets and reports, and link cells from project plan sheets to an overview portfolio sheet. Recently I've seen where some cells link properly, but some cells don't. I've tried removing the links and re-linking, but to no avail. Guidance is appreciated.
-
Should I use a Report or a formula?
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what would I need to do? Could I use a report or a formula.
