-
What formula to add to a "Days Remaining" field to pull from a date box
Hello, I am trying to create a formula for a column that will determine the number of days remaining from an expiration date. Furthermore, if possible, I would like a status indicator (green, yellow or red button) to remain statically green until the "Days Remaining" field gets down to 30 days remaining. At this point, I'm…
-
Moving rows and losing formulae links.
Hi there, I use smartsheet a lot to manage and track report issuing between multiple users. I regulary have problems when moving rows to enable organisation by priority and the cell links within the row change. I have to reapply the formulaes in certain cells which can be time consuming. has anyone else had this problem or…
-
Resource Availability
I need to figure out a way to view resource availability for a given time period, besides just visually scanning the resource view. Is there a way I can create a report that would tell me the dates that a given resource is not scheduled/assigned to a task across multiple sheets, so I can assess that resource (or group of…
-
text only column
I want to use a web form to populate Smartsheet. I have a field called "Section Number" that requires a text value. It is a 3 character field that will contain numerical characters like "001" or "020". I want that to be displayed as a text value in the Smartsheet cell. How to I accomplish that?
-
Can you create a filtered version of a smartsheet without having to link each link one by one?
I'm trying to create a live copy of sheet1 so I can filter and share with execs. I know I can link sheets but I don't want to do that every time a new tark is added. Is there a way to create a copy, add filters and have it updated as soon as I add new tasks?
-
Duration is not calculating correctly when using hours duration
Some parent rows have 0 days as the summationof the assocaited child rows and and some have arbitrary number of days. Since it is in a rollup value from child rows I cannot change. Any suggestions?
-
Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
-
If And Formula Help
Hi I am a new user of smartsheet. I need help on why this excel formual will not work. I get #UNPARSEABLE =IF(([Total Billed]40)<10000,0, IF(AND(([Total Billed]40)>=10000,([Total Billed]40)<20000),([GP Amount]40*5%, IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),([GP Amount]40*10%, IF(AND(([Total…
-
Gantt & Calendar Views on Reports
Thank you Smartsheet for the new feature allowing Gantt & Calendar Views on Reports! Best thing since sliced bread and dental floss!
-
Automatically add tasks to a web form populated row
Hi, I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form? I review sets of data that are submitted by multiple business unit and partner companies. The form this takes in always the same, and we have a set…