-
Locking row when being edited without saving
If several users are utilizing the same grid at the same time, the ability to immediately (without saving) lock that row from other users editing it would be amazing.
-
Create a Duplicate Flag
Hello, I am trying to create a flag that turns red when a duplicate name is entered. Here is the formula I have so far, but it keeps telling me it is "#Unparseable" =IF(COUNTIF([Client/Resident Name]:[Client/Resident Name]@cell) > 1, 1)
-
dropdown list dinamics or smart
buenas tardes! me seria de gran utilidad si alguno ha conseguido actualizar el listado de valores de la dropdown list con valores obtenidos de otra hoja.. desde ya agradezco y me seria muy util Gracias
-
Row Lookup
I have multiple project sheets with row items that are the same on each sheet and each row has a percentage of completion. I am trying to create a new summary sheet that has each row item as a column and return the percentage of completion. ie: row items "excavation, framing" etc. are column headings on the new summary…
-
Add Column to Row Report that was not in original sheet
Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. This column would have sensitive information in it that I do not want the other owners of the…
-
Formula to auto-summarise Delivery Risk assessment
Hi all, I'm attempting to build a function into my master milestone tracking sheet which will auto-populate my ‘Delivery Risk’ column, based on a series of conditions met in other cells in the row. Underpinning thinking is as follows: ‘Target Milestone Date’ are set for every row Assumption that ‘Actual Completion Date’…
-
Line Breaks in Text Fields on Forms
We would like to be able to use line breaks in the text fields of forms. For example, if you are typing data into a form linked to a smartsheet, it would be helpful to have the capability to skip lines or "enter" to the next line to continue inputting information. This would be helpful in both data organization and…
-
Merged: Find and Replace in Formulas Please!!
This discussion has been merged.
-
Editable Date and Contact Fields in Outlook Add-In
Presently the Outlook add-in for Smartsheet does not allow you to edit date or contact fields. I feel like it would be beneficial for those that track tasks in Smartsheet (from email requests) to assign due dates and email addresses in contact fields. We currently use a department smartsheet and a contact column to tell…
-
RAID Log Date Value Locking per column when status changes
Hello everyone, I have tried to find the best answer for this but I see too many threads and different responses. If anyone could help as I am new to this. I am only looking to lock in a date value on 2 columns whenever there is a status change, from when an issue is raised and then resolved. I know there is a record a…
