-
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
-
Links Not Working
Anyone else having issues with links to other Smartsheet sheets not working on and off? This is the second issue I have had this month. My table is not populating with the little arrow for the link showing as red versus blue. Error message says: Error: this link is invalid because the linked cell has been deleted. But, if…
-
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
-
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…
-
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
-
Will Smartsheet roll out an enhancement adding the ability to have more that 20,000 rows per sheet?
We use Smartsheet for several data repositories to feed data into other sheets via formula. We are running into issues because of the row limit in sheets. Will you be adjusting the sheet row limit, if so when?
-
How can I make FS dependencies start on the same date the predecessor ends?
Hi everyone, I’m migrating a schedule from MS Project to Smartsheet and I noticed a difference in how FS (Finish-to-Start) dependencies behave. In MS Project, when a task has an FS predecessor, the successor’s start date is set to the same day the predecessor ends. But in Smartsheet, the successor is pushed to start one…
-
Link existing table
Hi, I have a table which is linked to database and the table would have new row add. I want a table that have the same data and I can insert a new column to calculate the data. I've found some ways: Cell linking, Report, Connect Your First Sheet to a DataTable. If I use Cell linking, I need to maintain it manually. Report,…
-
Metric sheet not available in data source
I have a Metric sheet in my workspace in which I have admin/edit access. When I try to do a Countif formula on it, the metric sheet is not available in my data source list. Does anyone have suggestions? Thanks!
-
Not able to save
Hi, Is anyone else having difficulty saving their work? I have tried different browsers, giving it time to save and even redone work. When I go to save I get an error message and then I have to abandon all the work I did. Not sure why this is happening- it happed before, but now it seems to be more frequent. Any insight…