-
Issue with Fiscal Year
Hi! Our Fiscal Year begins in February. This means we are in fiscal year 2026, with the first quarter ending at the end of April. However, in my Smartsheet timeline, the year is off by a year. The timeline shows FY 2027 rather than FY 2026. Is there a way that I can change this?
-
Transfer Profile et al to a New Email Address
I need to transfer my discussions, community badges, level, and community profile to a new email address / Smartsheet account, as my previous company has gone out of business and I don't want to lose any of my Smartsheet details, comments, rewards, etc..
-
Submit a survey with contact as Mandatory field
Dear Community, I have created a form where the contact field is mandatory. If no value is selected in this field, the form correctly shows the error message: “This response is required.” However, if I select a name and then remove it, the field shows a remaining circular icon, and the form gets submitted without any…
-
Workspace cleanup without admin burden
Here's the situation: I'm trying to cleanup workspaces that are shared to me without admin burden on other users of the workspace. Here's my specific situation: 1. I am not the Owner of the Workspace. 2. I do, however, own one or more objects in the Workspace. 3. The Owner of the Workspace is not available (on sabbatical,…
-
Add multiple rows in a sheet when certain task type is added
We have some jobs that are repeated and require a standard set of tasks to be completed. I would like for when certain job types are added to a sheet that it creates a standard task list in another sheet. For exmple, when a kitchen renovation is added to the Sheet 1, I would like 10 specific tasks to be added to Sheet 2.…
-
Formulas in Reports - Any way to speed up?
Currently, I have a report connected to a single sheet. This sheet contains various formulas, including cross-sheet references. When data is added to the report, the formulas will not update/work unless the sheet is refreshed. Is there any way to have the formulas values "pop-up", or otherwise load? It is somewhat…
-
Changes to license requirements for Editing
I have hundreds of hours in building sheets that link multiple teams. This was all done on the premise that we wouldn't need 100s of licenses for simple cell updates. All of a sudden I am getting bombarded by users saying they cant edit only to find out we now need licenses? I love the Smartsheet core product but this has…
-
Workspace Sharing Question
Hi Everyone, We currently have a Smartsheet business plan and we wanted to know if it was possible to invite people into workspaces, but limiting what they see in the workspace. A few users would like to be able to edit some sheets within this workspace, but it is not allowed since their accounts are set as viewers. Is…
-
Creating a folder in SharePoint from Smartsheet and naming it based on row data
I'm a Power Automate Novice and I'm not experienced in expressions. I am building a data flow in Power Automate to create a new Sharepoint folder when a new row is created in my smartsheet. I can get to the stage of creating a new folder however I would like to name it based on cell data in the row. I have tried to use the…
-
creating mid-task lag?
In construction scheduling, we often have weather delays, lag when subs are working out of town, etc in which we need to create a delay mid-task. i.e., contractor A starts a task on 1/2, is delayed until 1/9 due to cold weather than picks back up and completes the task 7 days later than originally anticipated. Is there a…
