-
Formula issue
Hi Braine Trust I need some help with a formula I have Mobilization Date and need to create reports that will show me a list of people who have mobilized - Any one Mobing Week Prior to the Mob Date Any one Mobing The Week of the Mob Date A 2 week Forecast ( so two weeks prior to the Mob Date A 3 week forecast (so three…
-
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
-
Export to PDF Selected Rows
Hey all, Hoping this is an easy fix. I can't seem to print/export selected rows, only the entire sheet. I'm trying to document employees scorecards in one sheet for supervisors then have them export the individual employees row to review with them on a monthly basis but it won't let me do the selected rows button. Any…
-
Add Rows API - Not showing any data
I have a sheet where i have 2 columns. I have Customer and Item. In Customer Column I have a list of customers already * Customer * * ITEM * row 1 Office row 2 Shop row 3 Logistics row 4 Constructions row 5 Mapping row 6 Cartoon row 7 Office 2 row 8 Shop row 9 Logistics row 10 Constructions row 11 Mapping row 12 Cartoon…
-
Not allowing me to save the Automation
Hi Folks, I have Enterprise license and Admin privileges on the Smartsheet which my teammate has created and even then I am getting the below message. And this happens only when i add Request Approval automation step. Any suggestions are appreciated. Regards Ajay S
-
Card view: can I make color changes persist?
Is there a way I can make manual color changes persist? I cannot find a conditional formatting rule that overrides manual color changes, so it's a mystery to me why my team's changes disappear. Thanks for any advice or guidance!
-
Dynamic View 'Save' button is GREY
I have 2 dynamic views created for the client - same source sheets. However, upon changing the 'Workstream Group', the SS 1 photo's 'SAVE' button is greyed but in the SS 2 photo, it is not. I wonder what could be the issue. You might notice that the PIF No. is the same on both snips. SS 1 Photo SS 2 Photo
-
Automate Weekly Copy/Paste of Hierarchy
I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week column, and 3) Clear some of the data for the new week. While this doesn't take a long time for one sheet, I do a similar…
-
Hiding or deleting content via Automations
I have multiple sheets following a complex workflow. When some of my workflows are completed and moved to the next step in the process, I want the row of information on a sheet to be automatically hidden or deleted. I see that we have delete a column, but not a row. I need my row to be cleared after the data has already…
-
How to link parent between SS & Jira using connector?
Use case: Project created in SS using Epic, Task, Subtask (Parent, child, grandchild). Rows are indented to identify tasks and subtasks. Using Jira connector, data is pushed into Jira. Epic, tasks, and subtasks are created in Jira. Jira does not recognize the parent of a task or subtask. No parent is pushed back to SS…
