-
Extracting a Date from a Text String into a Date Column
I have data sent from my CRM into Smartsheet. The CRM will only export an appointment date and time together as one cell, formatted as: 2/09/2016 8:00:00 AM. I need the date to be in a separate column for filtering and formatting purposes. I've used a MID function to separate the date from the time using this formula:…
-
Adding an Primary Column item, which then updates another sheet.
Whats the best way to organize sheets so that when I add a new row (Primary Column item), it gets added to a corresponding sheet? For example, if I was to add a new person in our firm, I would like that person to show up across 2 other sheets as well.
-
Willing to Pay for a couple hours of formula setting
I am rookie and have never used formulas. Willing to pay someone to set formulas in a project for me that has 15 sheets.
-
Webform email address change available?
Hi Hope someone can assist in confirming something. When i send a link to a customer to complete a webform, the current email address noted in my inbox is - forms@smartsheet.com. Is there any way that I can customise that email address to be one of my companies instead? Is there a white label approach to smartsheet at all,…
-
Formula tool bar missing
I am rookie, but I cant find the formula toolbar only the conditional formatting. Please help
-
Viewing deleting rows
I've created a sheet that has 165 collaborators. They need to be able to change cell information. Occasionally the notification will say that a certain number of rows have been deleted. I need to be able to view what has been deleted to restore. The size of the sheet is currently 3,000 rows and changes are happening…
-
Freezing rows & minimize/maximize feature in sights
Dear smartsheet team, the freezing of rows would be more than helpful! I am working with Smartsheet on various customer projects and a have a great demand for this feature! Is there a status on how this goes? I think its a frequently asked question... Also regarding smartsheet sights, it would be great to add a feature…
-
regarding Auto Calculate Today date
Hi I Am Trying to set a Notification on a Collection sheet that i track Collection notes and Promised date when the customer Promised to pay now i have a date column which i type the date we need to call back the customer but is their a way to make auto Notifications any date that is past "today " Meaning to say if i set…
-
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…
-
ODBC Driver Enabling issue
Can any body let me know how to enable odbc driver for a licensed user