-
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…
-
Counting Distinct items.
=IF(COUNTIF({Client Name (Pruning)}, [Client Name]@row) = 0, "", COUNT(COLLECT({Annabelle Name}, {Client Name (Pruning)}, @cell = [Client Name]@row))) The above formula works great after receiving help from a member of this community :) The formula is counting the rows with the criteria; however, there are duplicates…
-
Best Practices of archiving sheets
Hello, I currently use a form to populate a sheet for any new sales leads. We're at the end of our fiscal year and I'm trying to archive all old leads and start a new sheet. I want to know about some best practices of achieving this. I was thinking about the following ways: Move all open leads via automation to a new sheet…
-
Modified "Report" for client
I have a contract with 262 units that are being reported into 10 database sheets. The finished product I am looking to have is a sheet with the 262 units displayed vertically with the Projects horizontally, with the quantity reported on each project in the row of the corresponding unit. I was successfully creating cross…
-
PROPER Function
Hi! I wanted to submit a feature request to add to Smartsheet. I organize a lot of documents that are displayed in all caps [Ex. PLEASE SUBMIT ADDITIONAL NEEDED DOCUMENTS]. I have noticed there is not an action/formula available that changes the text to PROPER like in excel [Ex. Please Submit Additional Needed Documents].…