-
how to sum the column amounts, if the status of each raw is Green and that is before end of may
trying to establish a quick summary report for Senior Management. want to sum the amounts in the contracts column, if the status of raw items are green and the date is happening before end of may. highly appreciate your guidance.
-
Contacts: Importing fails ERROR "No .csv"
I have read the articles on this topic and have tried saving in as many formats as I possibly can. All colums are named and in order as suggested (unless I am overlooking an error) Please help, I cannot import contacts!
-
Reminders
Im hoping to create a reminder or email 5 days before a due date? Is this possible??
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Conditional Formatting Based on Date / Number of Days
I have an sheet to track my employees. One of the columns is "Last Pay Raise Date". I would like to highlight a row when the number of days since last pay riase is greater then 180 days or something along those lines. Is that possible?
-
When a task is complete ahead of schedule the dependent tasks start date is not brought forward
Hello i have tasks a,b,c - all tasks are 2 days in duration task 'b' is dependent on 'a', and task 'c' id dependent on 'b' task 'a' was scheduled to start on 1/1/16, but it was started earlier and so it was marked complete on 31/12 how do i set it up so that task 'b' now slides along to 31/12 showing it is available to…
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Best way to load a file in sights that can be updated
I want to have pdf files on my site and an easy way to update them. I tried loading them in google drive but when I update the file in drive the link on my sight is still the original pdf. sometimes we update a pdf several times a day, what is the best way to do this?
-
how do i create a task with multiple durations/start/stop/start/stop structure?
Hello I have a task made up of multiple intervals, can smartsheet include these in the tasks/gannt? Example - task 'a' - start 28/4, finish 29/4, start (1) 2/5, finish (1) 4/5, start (2) 6/5, finish (2) 13/5 Thanks Alan Russell
-
% complete value not adjusting start date of next task
Hello I am hoping someone can help please, here is my problem I have a few tasks, dependent on each other - D is dependent on C, C is dependent on B, B is dependent on A etc etc. I have a complete tick box for them and also a % complete column Task A is complete, Task B is 40% complete, Task C is still showing it starting…
