Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Use a formula in project sheet start date for milestone?
Is it possible to use a formula in a project sheet's start and/or end date columns? I'm trying to have a date entered into a start date column in the project sheet based on a date entered as text in another text column. I've already found a formula that works to convert date-as-text to a date format, and I've confirmed the…
Delted a section of my worksheet and undo button does not go back far enough
Hi - any way of finding and re-instating the deleted section?
Unique Values
I searched Help and the Community for "unique value" and did not find anything. Is there a way for a field in a sheet to be unique? For example, I want the Document ID column to be unique. Let's say I do not want to use the Auto Number property. Is there a way to ensure that all values are unique in a column when anyone…
Entering a date with just Month/date
Does anyone know if you can enter just the month/date for the date information. I need to be able to just base my date column on Month/Date without the year.
Sum a range based on the status of a check box
I am trying to create a fomula to add two columns based on whether a Check Box is ticked or not? I think this should be pretty easy but have not been able to figure out. I have tried using IF statement with no luck.
Tracking Purchasing Approval
We are trying to find a way to track our purchasing process. I have created a sheet with a web form, but am having trouble with the approvals part of our process. Typically the purchaser would fill out the web form to request payment to a vendor or to themselves as reimbursement, then they need to get 2 approvals from…
Tracking Assets by location
I am not sure if this can be done in smart sheet. I need to track assets by location. There with be up to 50 assets by location and several thousand locations. I would also like t have the ability to add the bulk of the items from a location kit as all have common items with a few variables as to how many of each. All…
Lag days not included in project duration
Should the lag days not be included in the overall project duration? All tasks below the line in black, are subtasks and only the actual durations roll up.
Moving rows
Is there a way to move rows from one sheet to another and keep all the cell formulas that go with it?
How do I format a column for phone numbers?
I would like to format all input numbers to have the same format (xxx) xxx-xxxx
