-
Merged: "Log in as" Feature for System Admins
This discussion has been merged.
-
Aligning week number to financial year
Hiya, Asking this question again as I have still seen no solution here. In a gantt chart is it possible to align the week number with a financial year? In our business our financial year starts the first week of July - This however comes up as week 27, not week 1. Cheers
-
How to set-up Data Shuttle to show changes from the last time a workflow was run.
Hi! I'm trying to figure out how to set-up Data Shuttle to show changes from the last time a workflow was run. For example, I have a sheet with the following columns. "Job Title", "Job Code", "Posting Number" (Posting Number is the unique identifier) and "All Submitted Applications". "All Submitted Applications" is the…
-
Missing Jira field in SmartSheet Workflow
Hi team, I am unable to add some fields though those fields are available within Create and Edit Issue screens. Those missing fields as in the red box of a screenshot. Can you help to look into this issue, please? Thank you!
-
Count Rows Where A Value in Multiple Columns is blank
Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1…
-
Multi-select dropdown column to pull single value in another column
Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula for control 4 column ends up displaying a incorrect number "12." instead of "12.1" and control 5 column displays the whole…
-
Assignees Receiving Duplicate Email and Request Alerts...why?
So recently some of our users have began receiving duplicate email and request alerts. If this is an automation programming issue, I'm not understanding what is causing it (I have been using the same format for all of our vendors and workflows without this problem). Is anyone else experiencing this/have any advice on how…
-
Dependencies End Date Sets to Previous Day?
Hi! We have noticed that when Dependencies are on, filling an empty End Date cell (when the Start Date and Duration are also empty) with a date results in a cell value the day previous to the intended set date. Is this intentional, or is this a bug?
-
How can I make a multi-IF cross-sheet INDEX formula?
Hi there! I've been stumped on trying to make the correct formula for my situation. Any help is greatly appreciated! In one sheet (Data Collection sheet) I have a column for Sample ID and a column for Results. In another sheet that I'm using to report out, I have a column for the results of each possible sample ID. I want…
-
Transfer ownership of Smartsheet items
We created a workspace and made our client (from different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client (without having to do it one by one for…
