-
Cell shading not saving when I change it
everytime I update the cell shading to match the rest of the sheet or change to just be white, the change does not save, even if I save myself, it just goes back to the same way. from the picture I am trying to change the purple to grey and the white under the grey to grey
-
Printing the gantt chart
Hello, Is there a way to print ONLY the gantt chart and not the columns? Thank you!
-
Accessing Past Smartsheet Invoices
Despite diligently following SmartSheet's instructions on how to get support, including, but not limited to, messaging, emailing and calling Smartsheet, I have been unable to find a way to receive/download past SmartSheet invoices (ie an invoice for payment completed to SmartSheet). Our account was once with 10000ft and is…
-
Recurring Alerts/Update Requests for an entire sheet.
Hi, I have noticed that the criteria for sending update requests to an individual in a 'contacts' column can be set for a specific date, but I am looking for the ability to send a routine monthly reminders/updates to these individuals on a recurring basis. It appears the functionality for routine updates exist at a Row…
-
New "Workload Features" creating projects in Resource Management
I noticed today that I have a bunch of new random projects in Resource Management - whose owners are users who don't have RM access. My best guess is that the new "Workload Features" are creating projects in RM whenever a user clicks on it. Is that correct? Here's the issue.... I have enough trouble keeping RM clean and…
-
Setting Up If Statement with 3 Parts
I have a status column where I want the 3 options to be "Not Started, Work in Progress, or Complete". The "Not Started" status would come from the Comments & Date Closed column being blank. The "Work in Progress" status would be based on there being comments added, but the Date Closed has not been filled in. The…
-
Help getting the summary of my sheet
I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am using this formula: =COUNTIF(CHILDREN(Done2:Done130), 1) + " of " + COUNT(CHILDREN([Task Name]2:[Task Name]130)) + "" + "…
-
Formula linking one column to another sheet; =IF(ISBLANK) function
Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) function to display whether these records are "Complete" or if left blank in sheet one, "Incomplete". I have tried using the…
-
Add specific text to a row, if a condition is met in another column in the same row?
Hello, I would like to have Smart Sheet add the words "Bad Index" in the status column if index column is "647373". I can use conditional formatting to highlight the row, but when I try to use an automation trigger the whole column displays "Bad Index". This is my workflow. When I run the automation it marks the entire…
-
Hello - looking for help creating my sign in and out form.
I am fairly new (yet familiar with the possibilities available) in Smartsheet. I am in the process of creating a tracking form for my job to see anytime a device is in use and which employee is in possession of a shared device and what location they are working at that moment. I am collecting the employee's name and ID…