-
Move Projects in another Workspace/Folder with a Workflow
Hello Everybody, I am looking for a solution to move projects folders (control center) automatically after getting a milestone to another workspace or at least in another folder in a workspace. Is it possible? I don't have Bridge, but if I need Bridge to make this, I am also interested to understand how this would work.…
-
Sum if Multiple criteria matches across 2 sheets
Hi, I have two sheets containing a table of items. Sheet 1 is for entire item list and sheet 2 is for items used in a day. I want the sheet 1 to check the sheet 2 and reduce the numbers in the sheet 1 automatically. The problem I need to match two criterias. I tried following after making it work for one criteria. Any help…
-
Helper Formula for filtering contradicting Status
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
-
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…
-
Contact Field email extract
Dear Community, I have a form created which has contact field, i want extract only the email address from this contact. is this possible with any formulas.
-
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…