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 do you link an entire row?
I have several detailed gnatt charts for each of my projects as well as my groups projects. However the VP of our department would like to see a single gnatt that would only show all of the projects in a single gnatt. On this single gnatt it would only show the status of the Parent and not its childern. This way he would…
Articulate Quizmaker and Smartsheet
I am going ot be using Articulate Quizmaker to create stand alone quizzes. I wanted to pust the results of the quiz to smartsheet but can't see how I can do that. Can you provide some guidance?
I want to utilise an IF THEN function in Smart sheet
My example is to select a cost rate based on the employee title. If [cell1]="welder" then [cell2]=80, if [cell1]="crane operator"then [cell2]=100, etc, etc.
IF THIS AND THIS then TRUE CHECKBOX
Since Smartsheets currently doesn't have timestamping system I am using manual dates to do so however I need a checkbox to be ticked to alert me when two conditions have been met. These conditions are dates and are blank before data goes into them. What I thought would work is =IF(AND([Date1]1 > 0, [Date2]1 > 0), TRUE )…
Auto sort new rows
Hi, Is there a way to auto-sort new rows based on the existing sort criteria?
Conditional Formatting & Date Period
Hi Team, I am wanting to apply CF to a sheet with a date field. I would like to apply CF when a date falls (from todays date) within 3 months, another CF for 3-6months and another with 6+ months - thing is this becomes a 'rolling' CF, aeaning that at some point the CF will change or adapt based on todays date. I am not…
Using iPhone app to upload files from Gladinet Cloud
i can see the option to upload a file from gladinet but when I press to select gladinet I don't get any folder options...just a blank screen. Any ideas please?
Bold Milestones in Gantt View
Hello all, Is there any way to make the task name shown next to my milestone in gantt view bold so it stands out from the other tasks?? I have tried every menu and option I can think of with no change in how the task name appears. Thanks!
Date Formulas
I need to keep track of the day an item is approved. Is there a formula that I can use to generate a date that a check box is checked off?? Tiare
If Statement & Dropdown List
I have a dropdown list with 5 values and inserted an IF statement into the cells for that column to auto-fill 1 of the 5 values. I noticed when doing this you can no longer access the drop down list. Is there a way to auto-fill so the cell isn't blank to start but still allow users to access the 5 values in the list?