-
Left Function
In the Left function, is there a way to grab just the letters, not another character, such as a dash? I have a column of numbers that include 2-3 letters, a dash, a number, dash, then 1-3 letters. Example: XX-10000-WQA, XXX-10000-WQA. I would like to have a column that just shows the first 2-3 letters, without the dash, if…
-
Can a filter be applied to an already filtered list?
We are looking into transitioning our MS Access Drawing Index into Smartsheet. We need it to have the same filtering and search capabilities if we are to move forward with this transition. In the attached example, I need to filter the sheet so that it displays all records that contain the word "creek" in "title1" OR…
-
Invoice & Budget Tracking for Construction Projects - using Attachments
This is an easy way to keep track of your invoices
-
Copy & Paste Contact Cells between Sheets
Currently only able to copy and paste contact cells on a single sheet.
-
Adding Attachments to a specific row via Email
I am wondering if there is a way to send an email that would be connected to a specific sheet and a specific row for file attachments. I know other PM systems will allow you to send an email to a specific project and task that will add the attachments to that specific project or task. Is this possible? If so, how does one…
-
Merged: Allow editing of column type when conditional formatting is enabled
This discussion has been merged.
-
Force upper case on a column
Hello Everyone, I got a question. Is there any way to force upper case on a text column? I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font in it. Thanks
-
Please share the Formula to Capture Creation Date for Rows in smartsheet.
myself and my teammates are am using two separate sheet with data on each every week. I want a formula to enter that tells me the date of the last entry . How can I do this?
-
Merged: certain cells remain locked until specific data is entered in another cell
This discussion has been merged.
-
NETDAYS returning #INVALID DATA TYPE
Hi - I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type. They both contain dates. I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)". I have tried making the results column a…