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.
Discussion List
How to count quantity of date entries within a month time frame?
Hello All - I have 10 years of data that I would like to produce historical infomration, and eventually trailing charts. I want to produce a chart that will tell me how many leads we received on a per month, per year basis. I have shared a screen shot, and example of what I am trying to do. I keep getting a "zero" for a…
Is it possible to create a link for each column to be copy and paste elsewhere?
Hi, The feature I am looking for is basically to copy a link to a row for pasting it in my iCal at the event that corresponds. For instance, if I have to call the Opportunity in row 100 at 4pm, I will manually create an event in my iCal (becasue SmartSheet sync with iCal only adds them as all day events). In the event in…
Trying to validate date fields in some way.
Hi I have created a sheet so that our Admin team here can accurately record sales information and can then run reports to calculate commission figures. I can share this sheet if anyone would like to see it. I am using a lot of conditional formatting to avoid input errors so that the output reports are accurate and correct.…
How do I archive a workspace after I've completed a project?
I still want to have access to the information but I'd like to store it somewhere out of immediate view after the project is complete.
IF statement formatting based on data in multiple columns
Hi, I have a sheet that includes Start Date, Finish Date and Status Columns. I'd like to create an IF formula that considers data in all three columns in order to create color coded balls as shown here (https://www.smartsheet.com/blog/support-tip-automate-RYG-balls). Specifically, I'd like the logic to be: If Start is…
Vertical Text
Can Smartsheet Format Vertical Text to Keep a column thinner?
Exclude values based on formatting
i.e. exclude red from a SUM function, so all the red values are not added up
Recurring Milestones in Gantt Chart
Hi - I'd like to create a recurring milestone in a gantt chart. Do I need to create multiple activities on the list view or is there a formula that will generate a recurrence for a single activity? Thanks!
SmartSheet Function Similar to Excel MOD Function?
Is there a SmartSheet function similar to Excel's MOD function. I need to create an IF statement based on if a quotient is a whole number/integer or has a decimal (has a remainder after division).
expired trial to member of team plan
i apologize in advance if this was asked before, but i didn't find it in the forum yet. i have a user that was on a trial to gain access to a sheet that she is one of many users of this particular sheet. Her trial expired and i sent her an invite (used her same email address) from our team account, but it was not as a…
