-
Having link to Smartsheet on our intranet
Hi all! I work in the Communications department and we keep a tracker of all of the events for the year. It used to be an Excel spreadsheet and we put a link to it on our Intranet page for all staff to access. Now we keep it in Smartsheet, and I've only given access to my team. Is there a way for folks outside my…
-
Checking what Months are during a Project
Hi, I've tried to find a solution for this, but maybe it's a too generic wording problem. We have a Master Project list, that has the start and end date of every project we have, as well as it's budget and projected profits. I want to have an overview of how much money is allocated to each month and for that I need to…
-
This rule triggered itself directly or by at least 1 other rule, which is prevented.
I have a SmartSheet constructed as follows: 1. A dropdown list contains five options to indicate the task status (Column = "Pickup Status"). Pickup Status Pending... Pickup Now Do NOT Pickup Pickup Completed Unable to Pickup 2 . The Foreman will use a form to submit the initial data and set a hidden field to "Pickup Status…
-
SUM Function
I am trying to calculate Percentage Complete on a task (Project). I know the Percentage Left (that calculation is working perfect), but the Percentage Complete works on one sheet and not another. =SUM(1 - [Percentage Left]4) On the next sheet I try the same thing and all I get is the return of the function syntax. Any…
-
RYG formula not working
I have been researching formulas trying to find solutions without having to tap into the community and duplicate my question with others, however, I really am stuck. Trying to create a formula for RYG based on planned finish date and status. Here is what I wrote - unparsable is the error. Are there supposed to be spaces…
-
Calendars
2 Part Question I want to make 2 employee calendars 1 for vacation another for PTO. Can I create just calendars? I created an installation sheet and a service request sheet. Is there anyway to merge the 2 calendars and color code the installation separate from service request. I would like to be able to view 1 calendar to…
-
Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it. However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go…
-
Automated RYG Balls
Greetings Smartsheet Community! I am working on a formula to automate the RYG balls in a status column that references data in the cells of 3 columns, and it seems to be working well. I am wondering if there is a way to add to the formula so that the status column stays blank until the data in the reference cells is…
-
Anyone using Jira tasks in Smartsheets currently here??
Anyone using Jira tasks in Smartsheets currently here or do you know anyone ?? Please share the best practices adopted by you
-
Updates are not visible
I have a MSFT- Promo account and a month ago I created recurring Update Requests that are being sent out to my 17 customers. Since the upgrade last week, I cannot find the Updates that I created but they are still being sent out (yes, I checked Alerts and Actions). I keep getting a message "Upgrade to Business or…
