I was wondering if there is a way to make a date column go N/A unless needed for a specific row or rows.
For Example:
I only want the Delivery Date Column to be active when it comes to Deliveries. Is there a way to do this or no?
Please Help
Thank You.
=if([column2]1="Delivery",[date reference],"N/A")
I have a set list of statuses that I want to keep track of and collect durations. For example, when the status changes to Sent to Lab (Ongoing), I want it to record a date in the Sent to Lab column. I feel like it should be an easy thing to do I just can't get it right.
I am trying to have a sheet that reports multiple sheets. I have merged cells and that works but I am looking to merge a whole row of dates to a single cell with the most current date featured.
Our whole operation has ground to a halt as the cell limit of 500,000 has been hit. I reduced the number of columns such that the total amount of cells is now well under 500,000. Yet the sheet and form attached still remains inactive. How do I reactivate? Thanks for any assistance from the Smartsheet community. Rgds, Dave
Help shape the future of Smartsheet. Share your ideas and feature requests.