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
Count down in days formula
I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each task and predecessors I then have the calculated "finish date" column for each tasks and each phase. I need to create a…
Publish - access to anyone with a link
This option is disabled for me. What should i do to enable it?
Modified Date Updated by Comments
Hello, Is there a way to have the Auto-Number (Modified-Date) column update by adding a comment in a row? I'm aware that the date can automatically change if another portion of the row is updated, but that's not what I'm looking for.
Formula Help
Hi try to get a formula to do this. If “DATE PAID” is blank, copy balance from “TOTAL CHARGES”
Commenting your code
Where do you comment your code? When working on a big sheet that you may have to come back to months from now, or a system of sheets you are working on with other Admins, how do you document code 'inline'? Hidden columns? Attachments? What have you found successful?
JIRA Integration: automatically fill in "Start Date" when a Status has been changed?
Hi Smartsheet Community, We've integrated JIRA into Smartsheet. We're looking to automate some more fields. When using the gantt charts, some of the field we are manually filling are and Start Date and End Date. Is it possible to accomplish the following? 1) When a JIRA [Status] has been switched from To-Do --> In Progress…
admin access - cannot delete columns?
A coworker that has admin access to a sheet I own cannot delete a column. I believe admin access allows you to do so. Has that changed?
Planing a load of production
Hello I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees. I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell. =IF(ISERROR(PRORATE($[Total hours]32, $Start32,…
Calculating Next Invoice Requisition Date
i Am Invocing our Clients every 2 weeks "Biweekly " I have A sheet set up like this Managers Name who Reprots progress Done Next i have a Coulmn called Date send Which is the Date we emailed The Invoice /Req To our customer Then i have Next Req Date Which should be calculated 2 weeks after the prior Send date Here is my…
Right Align - character cut off
This is only a minor annoyance, but SmartSheet cuts off the right-most character in cells that are aligned right. I can't find a simple solution to this. Any ideas?