I am trying to extract the month and year out of a date column and join them to create a unique key. For example the value in the date column is 8/18/2017 I need a formula to return 82017 I can extrac…
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fir…
Hello there I am a new user and am stuck! My Gantt chart doesn't seem to update project info from the start and end dates. Also the top bar of the Gantt Chart has irrelevant dates that I cant seem to …
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly apprec…
Hello, I would like Smartsheet to automatically assign a project status based on duration and number of days behind project. I have specifically been asked to assign a project status of red if the tas…
Hello, My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run …
Cant get my formula to work =( Please help =IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0))) If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent…
Cell merge function I have seen that this function is still not in place. Can anyone tell me when this function will be implemented? Or is there a way, where I can use a text in one my Project templat…
I have a report I use which gives me all tasks in my projects that are overdue, due today, or due tomorrow. (A screenshot of the report builder is attached, below.) It stopped working properly yesterd…
Hello, I have a report being built off of 10 different sheets. Each sheet name is prefixed with a number and followed by the name (1. Project Name, 2. Project Name, etc). All was working well and the …