-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
-
Alert Notifications
Hi I have set up a rule so that when a specific status changes to 'Required' the person assigned to the action gets and alert. We are only receiving a Smartsheet notification not an actual email. I have checked the account settings and we are set up for email notifications - any ideas what I am doing? Rs Abbie
-
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…
