-
can smartsheet support "comments" and “cell merge”?
Hello, I am wondering whether smartsheet can support "comments" and “cell merge”? -Cell comments: Write a comments for the value in the cell, like excel? - Cell merge: merge the adjacent cells as one cell - Two level columns headers: Ex: Level 1: Jan Level 2: Qty, Amount, Price Now I can only write header as: Jan qty, Jan…
-
linking rows with attachements
is there a way to link an entire row to multiple sheets along with attachements? or simply link attachements ?
-
Training Plans - Central & Individual
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
-
Copying Cell Linking
Is there a way to copy and paste a row and retain its cell links to the pasted row?
-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
Individual formula editing changes the whole column
Not sure if this is supposed to happen, but since i was not expecting it at all, i found it extremely frustrating. So i have a spreadsheet that is using several index/match formulas on different columns to pull information from other spreadsheets. But today, one of the Admins on another spreadsheet made me aware that he…
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
-
Can smartsheet auto-populate cells based on the above cells in a column like excel does?
Can smartsheet auto-populate cells based on the above cells in a column like excel do? When completing text cells the system doesn't indicate that text word is already above? This is useful not to duplicate like currently, excel can do it by default. Any idea if this is possible or can be enabled would be appreciated.
-
SUMIFS Based on Parent and Children Criteria
Hi there! I am trying to make a master reporting sheet that is just a sum of another source sheet based on specific criteria of parent and child rows. It's a two step SUMIFS that I can't seem to get straight. It would need to be a sum "grand total count", if hierarchy 0 month = specified month and hierarchy 1 matches…
-
getting cell value by row id and column id
Hi, I am the primary column id. I want to iterate over rows and get cellvalues of the primary col in python. for MyRow in my_sheet.rows: After this is there any direct function to get the cell value using parameters MyRow.id,primary_col_id? Thanks