-
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…
-
Limitation: Cannot delete more than 5 columns at once.
Why is this even a limitation?
-
Document Builder - Adobe Calculated Fields
Hello community, I am currently loading a PDF that was made using adobe acrobat pro into the Document Builder as a template. There is a date field that always needs to default to today's date. I currently have the field calculating off the following script: var today = new Date(); event.value = util.printd("m/d/yyyy",…
-
Elapsed duration is calculating one additional day
if I use e10d in duration column to ignore non working days its calculating one additional day, for example if I set the duration as e10d and the task start date is 01Dec2022, the end date should be 10Dec2022 right but its showing 11Dec2022 as end date.