-
Formula Help: Count "To Do" for rows with start date in June
I am currently using this function =COUNTIF(Status:Status, "To Do") to identify the total number of tasks with the status of "To Do". I'd now like to break this out to count the total number of "to do" that start in June for example. How can I add this additional ask for the date? Thanks!
-
Line Chart Not Charting Correct Data
I'm having trouble getting a line chart to chart the appropriate data. I am tracking KPIs for my sales team and collecting in a source sheet. I then have a report for each sales person that pulls their data from that sheet. I have made each of them a dashboard so they can see their progress and I want to charge their data…
-
Curious about Form capability
Hi, would it be possible to use a form to get data into a sheet and instead of creating a new line of data it can add into an existing line? Attached an example.
-
End date not accounting duration properly
I have a task with a duration of 12 hours. Smartsheet is showing the end date same as the start date - say, starts today and ends today. Secondly, a dependent task for the same resource has a duration of 4 hours. This should make the subsequent task start on the same day, but I see it start on the next day. (See graphic,…
-
Is there a work around? Alert or Update Request?
I'll keep this simple. In the method I'm using the form every person that uses the form is not required to make a Smartsheet account. They have too many logins and adding another "software" to the mix is not going to go over well; however, they are fine using the form. This means I'm not able to take advantage of the…
-
Limiting what customers can and cannot see for projects
We use smartsheets to run our customer projects. The approach we have used to date is to create a workspace for each customer, with the necessary sheets - all from a template. This works really well, as the customers need to review and contribute to several of the sheets that we use, and the workspace sharing feature lets…
-
Automated emails for reports not working properly
We have 2 automated reports for scheduling that have been sending to our SmartSheet groups via email each day however over the last two days these reports have stopped working. To monitor I added myself to the list yesterday and still this did not send. I did not see any reported outages. I made a small change to the job…
-
Working with the Automations
Our organization is fairly new to smartsheets. We are using forms to collect data, but the hiccup that I have ran into is that I can't seem to automate a process that could flag duplicate entries, so that the individual who fills out the form, will receive an email to update their entry. Not sure if this is something that…
-
How to Apply Weekly Updates to Dashboard
I have a smartsheet file that is updated weekly. I'd like to be able to capture that weekly data automatically on my dashboard. Is this possible? Thanks
-
Auto/number - date on particular cell, not whole row
I'm trying to find a way how to populate a datestamp in a cell based on the last change from an another cell in a particular column fe: Row 1 - column A: dropdown (Start, pending, stop) Row 1 - Column B: I want the date when Status changed on column A Auto/number - date: works, but it looks at every cell on that row, i…
