-
Auto Populate Children Dates based on the parent first day of the month
Good evening - I am looking to create an auto date that maxes based on the month (i.e. 28 days in February or 30 days in September) based on the parent row. I originally had it by calendar year and organized by the Month as the parent, and that parent row has several values that are linked to other sheets, however, I was…
-
At Risk Formula that utilizes end date and status columns only...
I am stumped. I have tried various formulas only for them to error. The closest I have come is the following but I am missing pieces. =IF([End Date]@row = "", 0, IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1)) BUT... I need it to do more: I need it to NOT USE % Complete I need it to flag at least 14 days prior…
-
Setting up a sheet with names
How can I have a calculation sheet where all the names of the main project sheet will appear on, automatically? So for example, someone new has joined the project. They have a task now, on the main project sheet. I would like this person's name (so they are in the "assigned to" column) to show up on the calculation sheet…
-
How do I override a row in a secondary sheet when the info is updated in the master sheet?
I have a Master sheet where all of the data is stored. I also have other secondary sheets that have just the applicable columns for those groups of people. When I update a date or cell in the master sheet, is there a way to either just update that same column in the secondary sheet with the new info or copy the entire row…
-
Share sheets as hidden
When sharing a report that needs to be edited i also need to share the sheet onto the person editing. For some of my sheets this can cause GDPR concerns as i don't have sheets per company only sheets per process. (It would kill all efficiency to have to create a sheet per company for each process). If i could share the…
-
Search function not always working on iOS
Hi everyone, I created some new spreadsheets today, and while I'm able to use the search function fine on the computer, when I search the same thing on the mobile app I get no results. I'm still able to search many other sheets on mobile, but not the new ones that I created in the last hour. Is there a fix for this?…
-
Jira Integration - follow Row across sheets
I have a workflow for my team that uses 3 sheets. All requests come into the 'Intake' sheet using the Smartsheet form. Once approved, those rows are moved to the 'in progress' sheet. Once completed, those rows are moved to the 'completed' sheet. I have certain requests that require I engage a separate team which works out…
-
Cell reference - when original cell content is deleted, the referencing cell still shows value
I have two Sheets. In Sheet A I have my full content. I am displaying some cell content from Sheet A in my Sheet B. I created the referencing as a Column Formula, so that if I add another row to my Sheet A, it automatically displays in Sheet B. That works just find. What does not work is if I later on decide to delete a…
-
Split a list into columns?
Hi, I have a list in a column which is separated by commas. I need each number in the column to be split into it's on column. Is there a way to do this? Thank you
-
Can one form link to two sheets?
Hi, I created one form but can the data be linked to two different sheets? Thanks.
