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. Archived 2017 Posts
Archives for February 2017
Discussion List
Saving over other entries
I know SS will tell me when another user is viewing the tab, and it will tell me when they make changes so I can refresh. The challenges we're facing are: there's a good 30-45 seconds before SS tells me that someone is viewing the tab. That's plenty of time for them to get in, make a change, save it, and have me save what…
Forced dates when dependency is enabled
We are working to importa 1800 line project plan into smartsheet and have run into a dabilitating problem with the dates. What looks to be happening is that the “Duration” and “predecessors” fields are completely driving the dates for the tasks. Anything with a predecessor is automatically forcing the start date to be the…
Copy and paste text from email
I have a smartsheet set up for RFI's (request for information) on a project. If somebody sends a query by email, how can i copy and paste the text from the email into the smartsheet ? I copy the text but 'paste' is greyed out when i try to put it into smartsheet ? Urgent help needed please so i can pack up for the weekend…
Multiple users update request
I have 600 rows of data mapped it to 40 to 50 owners. each owner has multiple rows assigned. While requesting for update request, am sorting and selecting owner wise rows and sending mail notification seperately for each owner. (40 times). If I select all the rows and send, all owners others are able to see/update the…
Within a SUMIFS statement, can you extract the hour from a timestamp and use it as criteria?
Hello all, I have a problem that has been driving me mad - I would be grateful of some help! I have a spreadsheet where: Column A contains names (text string) Coumn B contains costs (numbers) Colum C contains a timestamp in the format dd/mm/yy hh:mm:ss I want to be able to create a formula that says "add up all the costs…
Show default duration either in months, weeks
How can I set to show default duration in months, weeks or so? Please add this feature if its not already available.
% Calculations On children
HI Community I have A Quick Question On % Calculations I have a Payment Sechdule Which has a a main Name For example Wall Framing Under Wall Framing i have indent Wall framing on Floor 1, Floor 2 etc, And i ran =SUM(CHILDREN()) To calculate Total We charge on Wall framing Now For my customer i want to send only The Main…
Schedule Cell Linking w/Lag
I have linked multiple project schedules together, but I'm wondering if there is a way to add lag time between the links? Currently the finish concrete completion date of the first becomes the clearing and grubbing start of the second, but I'm wanting to add a one week lag time between the two while keeping them linked.…
Including just the latest comments
I would like to be able to send project tasks out to folks, but only include the last comment or comments limited to a certain date range. As it is currently designed, it all or nothing. I 'd like to be able to have a status meeting... then post my updates as comments to the applicable lines and then select those lines and…
Automatically linking cells/sheets
I want to create a sheet that will automatically add any task that has been assigned to me in other sheets. Is it possible to set this up so it will happen automatically? I would like to avoid having to manually add every new task I am assigned from every project I am working on. Ideally I would like to set this up for my…