Best Of
Re: Creating new Sheets in "Sheets" folder
I came here to say that I can't stand the new method. I have now wasted 15 minutes trying to figure out how to get my workspace sheet into my sheets folder.
File-save as new only gives me other workspaces as options.
You know the place where all my sheets over the last few years have been created and organized. Now it seems we are being forced out of.
In one sentence or less. How do I move my newly made workspace sheet into my sheets folder? If that is not possible, please make the fix.
Jared P
Re: Are you planning to upgrade to Jira v10 in the near future?
Hi all - I wanted to share an update here! We are working on a fix for Jira Data Center v10 compatibility but have run into a snag due to an Atlassian bug in v10, JRASERVER-78833, that affects the functionality of the Smartsheet Jira Connector.
While we are exploring alternate workarounds, for expediency, we would appreciate if you could comment on the Atlassian ticket if you are waiting for v10 compatibility to let Atlassian know how this affects the Smartsheet Jira Connector functionality and ask for prioritization here.
We’ll continue to keep you in the loop as the situation develops and are working to have a solution available as soon as possible.
Danielle Wilson
Re: Using If/or/and to change date based on different drop downs and checkmark selections
I checked your formula with a demo sheet below, and found that the following part is causing the error;
OR(logical_expression1, ISERROR([column]@row))
First, in your formula below, from your comment 'The bone column is either "NA" or various types of bones', I guess the [Decal Start / Trim]@row should be Bone@row.
IF(OR([Decal Start / Trim]@row = "NA", ISERROR([Decal Start / Trim]@row)), vs IF(OR(Bone@row = "NA", ISERROR(Bone@row)),
See the [QC - OR (Bone)] formula below in the All Formulas.
Then, I tested various formats to give Workday@row to the QC column if Bone is NA or ISERROR. BYW, [Workday] and [Workday Extended] are the two helper columns with the WORKDAY formula to make the main formula easy to understand. (See the [Workday] and [Workday Extended] formulas below.)
Test 1
[Bone OR] =IF(OR(Bone@row = "NA", [Bone is Error]@row), Workday@row, "Other")
The [Bone OR] =IF(OR(Bone@row = "NA", [Bone is Error]@row), Workday@row, "Other") formula, as the one in your formula, gives me the #INVALID VALUE error.
Test 2
[ISERROR(Bone)] =IF(ISERROR(Bone@row), Workday@row, IF(Bone@row = "NA", Workday@row, "Other"))
The [ISERROR(Bone)] =IF(ISERROR(Bone@row), Workday@row, IF(Bone@row = "NA", Workday@row, "Other")) formula, which does not use the OR function, also gives an error.
Test 3
[Bone IF IF] =IF([Bone is Error]@row, Workday@row, IF(Bone@row = "NA", Workday@row, "Other")) [Bone is Error] =ISERROR(Bone@row)
Lastly, I used a helper checkbox column, [Bone is Error], with the ISERROR(Bone@row) formula, and combined the two with the IF clauses as shown above. This format gives no error.
So, I incorporated this format in the following formula;
[QC 2] =IF([Bone is Error]@row, Workday@row, IF(Bone@row = "NA", Workday@row, IF([Last Nx/End Date]@row = "", "01/01/22", IF([Histology Requested]@row = "No", [Last Nx/End Date]@row, IF([Timeline Extension]@row = 0, Workday@row, [Workday Extended]@row)))))
I do not understand why Smartsheet does not accept the two other formats, but the above format seems to work.😅
All Formulas
[QC ] =IF([Last Nx/End Date]@row = "", "01/01/22", IF([Histology Requested]@row = "No", [Last Nx/End Date]@row, IF(OR([Decal Start / Trim]@row = "NA", ISERROR([Decal Start / Trim]@row)), WORKDAY([Stain / Scan]@row, 1, {KAN Holidays Range 1}), IF([Timeline Extension]@row = 0, WORKDAY([Stain / Scan]@row, 1, {KAN Holidays Range 1}), WORKDAY([Stain / Scan]@row, [Days Extended]@row + 1, {KAN Holidays Range 1})))))
[QC - OR (Bone)] =IF([Last Nx/End Date]@row = "", "01/01/22", IF([Histology Requested]@row = "No", [Last Nx/End Date]@row, IF(OR(Bone@row = "NA", ISERROR(Bone@row)), WORKDAY([Stain / Scan]@row, 1, {KAN Holidays Range 1}), IF([Timeline Extension]@row = 0, WORKDAY([Stain / Scan]@row, 1, {KAN Holidays Range 1}), WORKDAY([Stain / Scan]@row, [Days Extended]@row + 1, {KAN Holidays Range 1})))))
[Bone OR] =IF(OR(Bone@row = "NA", [Bone is Error]@row), Workday@row, "Other")
[ISERROR(Bone)] =IF(ISERROR(Bone@row), Workday@row, IF(Bone@row = "NA", Workday@row, "Other"))
[Bone IF IF] =IF([Bone is Error]@row, Workday@row, IF(Bone@row = "NA", Workday@row, "Other"))
[QC 2] =IF([Bone is Error]@row, Workday@row, IF(Bone@row = "NA", Workday@row, IF([Last Nx/End Date]@row = "", "01/01/22", IF([Histology Requested]@row = "No", [Last Nx/End Date]@row, IF([Timeline Extension]@row = 0, Workday@row, [Workday Extended]@row)))))
[Bone is Error] =ISERROR(Bone@row)
[Workday] =WORKDAY([Stain / Scan]@row, 1, {KAN Holidays Range 1})
[Workday Extended] =WORKDAY([Stain / Scan]@row, [Days Extended]@row + 1, {KAN Holidays Range 1})
Re: Timeline view in Dashboard
Any updates on the ability to show the timeline view in dashboards?
K Cook
Re: Timeline view in Dashboard
Agree 10000% to all above comments, PLEASE get the timeline view on the dashboard!!
Lisa Casello
Re: Timeline view in Dashboard
Being able to have timeline view on the dashboard would fill some gaps for us too.
I concur with the previous comments.
RJMSourcewell
Re: Timeline view in Dashboard
We are currently using the Timeline in a release management sheet to show when projects are being piloted, rolled out, etc. Adding this to the dashboard will greatly enhance the timeline capabilities.
CarolynD
Re: Forms: Ranking choices in a question
@Ramzi K is there a solution to prevent a user from selecting all 5 items as priority 1 as it looks like @Long@Concur and @Jlaustse had noted this as an issue in 2021. Is there a solution or way to create logic for this? I have 12 Topics and want to find out the top 5 priorities from participants. Thank you!
HeatherM
Re: Export Group User List
Need report options to export Users by User Group.
Currently we can export two reports:
- User Management > More Actions > User List
This report - this shows all Users, but not their group assignments. - Group Management > Generate Group Sheet Access
This report shows objects to groups, but not the users.
douglas.martin