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
Can you only indent to 1 level or is there a way to allow further indents?
Can you only indent to 1 level or is there a way to allow further indents?
Program Report
Hi There, Im trying to create a report on tasks that are programmeed to be undertaken in a specified date range (but not necccesarily starting or finising in that same date range). For example: I have a task that starts on the 1st of February and ends on the 20th February (i.e 21 days of work to complete the task) I want…
Mixing overwrite with formula
Hi-- so, I have a wonderful formula in a cell whereby depending on the dropdown choice selected in another cell, X, Z, Y occurs in the cell where the formula resides. What concerns me is that sometimes a situation may occur where overwriting that formula is temporarily necessary. But we don't want to lose the formula there…
working days
heres the thin. in general we set projects as five working days, sure we all work weekends but in terms of setting teh critical path five working days works best. problem comes when we get to teh latter stages of a project and goods are being managed through the supply chain which is a 7day a week process ie goods…
inadvertent formatting
Hi, I seem to have pressed a key or series of keys that has pushed the contents of some number cells over to the right a little thus shaving off a little of the number and i can't work out how I did it. Please see screenshot. Anybody got any ideas please? Thank you. Si.
IF/AND Formula
Hi, I am following identical logic to another formula in my sheet that is working, so I cannot for the life of me figure out why this is not: =IF(AND(Eval Payment Status]1 = "Appointment Pending (pay plan)", [Initial Pay Plan Amount Due]1 = 0), 1, 0) Here, I am trying to establish that IF Eval Payment Status shows…
Search content within an attached document and metadata
Saw a bunch of post about search and it not searching what everyone needs it to. My suggestion, the two biggest features of SharePoint are SEARCH and RESTORING deleted rows (items). SS - C'mon man. You gotsta prioritize this. Admins have to sleep at night.
An Admin deleted bucket
Saw a few threads regarding years of no action by SS to give the Admin the ability to restore deleted rows. My suggestion, why not allow users with edit rights to delete rows, but not allow them to see the deleted items. This is where the admin will go when the team screams that someone deleted a row or rows. SharePoint…
Invoicing formula, am I on the right track ?
When a job is invoiced say on and between Jan 1st till Jan 31st (Invoice Date]:2 then the commissions will be paid the 20th of the following month Feb 20th[Paid Date]:2 Im assuming a nested If statement would be needed for each month? assuming of course. If someone can help get me stated, that would be very helpful. Thank…
Smart Sheet Reminders ....
Can you set smart sheet reminders to remind you at specific times ? - Sometimes i talking with a customer mid morning and i need a reminder to go off later in that afternoon