-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Splitting Update Request
So, we send out quarterly update requests to various different departments...more specifically, to named individuals within those departments whose details are held within a Contacts column. These updates are timed so that they automatically go out a number of days before a data entry deadline. Due to the variation in data…
-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Is my alert too redundant?
Did I set up this alert to be too specific? I want to have an individual notified when a row to which they are assigned to has the status change to "In Progress". I'm trying to test it now but have doubts about the "In a row where any status is In Progress" line I included. The red in the picture is where my colleague's…
-
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
-
Finding and returning values in a range of cells
Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certain value, and join them together. For example, say I had a row with 4 columns that say…
-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
Re-using Update Request Links
Is there a way to re-use an Update Request link? For example, if I opened an update request and I am not ready to post a response, is there a way to open the Update Request again? The Update Request link is a one-time only link right? Is there a way to work around that? Thank you
-
Automated Update Requests based on 'Assigned To'
Hi I'd like to set up automated update requests to be sent out on a bi-weekly basis with a pre-defined set of fields to be completed in the update form. I don't have a trigger for this, I'd just like people to provide updates to their project, rather than trigger this from a change in a particular field. Any thoughts as to…
