-
Countifs formula using or
Hello. I am trying to count the RYG ball (in this case red) for each team. One of our teams is comprised of three sub-teams, so I need for it to be counted if any of those show a red ball. How do I create or for the Team section of this formula? =COUNTIFS([Overall KPO Status]:[Overall KPO Status], "Red", Team:Team,…
-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
-
Show days left in Smartsheet
Hi, I'm total newbie in Excel functions. I want to show the days left from a date. So I have the follow formula which works: =[Column-Name]23 - TODAY() This only works for row 23 of course. But I just want the current row in it so I can use the same formula in every row. So In row 8 it uses the date from row 8, in row 9…
-
Sight counting widget
How do I create a counting widget in sight edit?
-
Sending Attachments
I want to send/share a row with someone and I want them to be able to see the images in the attachments without having to open them. For instance, I need to send a General Contractor a Weekly Report of work completed. There are attached images on a row that need to be sent to him. I could share the row, but it would not…
-
Email Notification - How robust is it?
We like the email notification feature, but one of our engineer who has a good Network/Internet knowledge has raised a concern about this. He claims that at this very moment, it looks fine. The email path (sorry for my childish words..) is directly connected to Google and there is no ISP in between, but there is no…
-
Report planned work on a weekly basis
Is there a way to know the estimated % of work to be done every week? I didn't find a report about this, but this will be very helpful to track the overall execution of a project. Example: week 1=5%; week 2=18%; week 3=24%; week 4=32%; etc...
-
Adding Workdays to a Formula
Hi SmartPeople - I am trying to create a formula that adds "work days" to a date. Example: I have a "Date Reported" column and a "Date Due" column. The "Date Due" column is a formula based column that should add a specific number of days (either 5, 10, or 20) based on a given priority in the "Priority" column. However,…
-
Alerts and Notifications not working
Hi guys, im creating new Smartsheet project and i setup duedate, but i am not geeting any reminder mail to my email about experation due date. pls help
-
Is there a way to edit recipients when scheduling sending a reoccurring report?
I have some reports set up to be sent as attachment to people on a reoccurring basis. The distribution list occasionally changes. When this happens, it appears that I have to delete the schedule and start from scratch, however I am able to edit the schedule of when it is sent and frequency. This can be a pain when there is…
