-
Nesting SUBSTITUTE functions
Hello All, I need help!!! I am trying to write a formula that replaces the letter "a" with the number "1", "b" with "2", "c" with "3", etc.... The individual formula of (ex.) =SUBSTITUTE([Column3]1, "a", "1") is easy enough, but for whatever reason I can't seem to figure out how to nest it with the rest of the letters and…
-
Attach File
I am trying to attache a pdf file that is 1.43 MB. (max file size is 256 MB) I tried with explorer and chrome. The far right hand of the row shows a green circle with a pie sliver which eventually disappears. The end result is no file gets loaded.
-
Editing Labels on Charts
Is it just me or are we not able to edit the chart labels anymore? They just brought out a bunch of a new charts and I can't seem to format word/number like I used to.
-
Anyone using Jira tasks in Smartsheets currently here??
Anyone using Jira tasks in Smartsheets currently here or do you know anyone ?? Please share the best practices adopted by you
-
Children not displayed
I have a list of that will not open up today. There are 671 children and the "+" and "-" changes but the rows are not displayed. Help please! Rose
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Linking to other cells
Hey, So we have 2 sheets. New Projects sheet and Tasks sheet. The New Projects one have 2 column. ID and name of the project, whenever we get a new project we insert the name and ID manually. I want the Tasks sheet to have those column as well (ID and name) and I want it to be dynamic. Meaning we add on Projects sheet, it…
-
Keeping Parent Card / Subtask relationship when moving card to another sheet.
Hello everyone. I was wondering if there is a way to keep the relationship between a parent card and its subtask intact when moving a sub-task between sheets. In our case this would be various departments who are assigned a sub-task then the card is moved to that departments board. When complete, the department would move…
-
Forms, Formula and fixes - Oh My!
Hello, I have created a web based form in which the user fills in certain information. As part of our metrics we need to keep track of when an quote is finished and completed. I have a date column for the quote finish and a checkbox cell for complete status. Our reports use the checkbox cell as the primary filter.…
-
wrong order of the assignments
Hello, During the last week i noticed that the order of the assignments in the sheet got wrong. Assignment number 1 became 10 (for examle). I have about 1000 assignments in this sheet it's really a big problem for me. In the beginning i tried to organize it again in the way i want to see it (and according to the row id),…
