-
=COUNTIF field has any value
Hello, My current incorrect statement is as follows: =COUNTIF(Plant:Plant, "DC", [Assigned To]:[Assigned To], NOT(ISBLANK([Assigned To]:[Assigned To]))) I am attempting to count the number of fields with any value in the "Assigned To" column with the plant column being "DC". I have made numerous failed attempts to find…
-
CALENDAR VIEW Date is not showing accurately
Some of our shared users are having trouble with the date showing up accurately in the Calendar view. I cannot seem to find a setting that would allow this to be changed. I have tried refreshing the screen, closing the browser and restarting it. but still they see the dates with Month 7778 example shown in screen shot…
-
Alerts
Hi, I am new to Smartsheet - early indication is it is an excellent piece of software and will help me enormously. I just cant seem to find a way of alerting the assigned to person (of the following task) once the previous task has been marked as complete. I would have thought this was quite a common task but cannot see…
-
Importing rows from Google Forms
Hi, I'm setting up a form in Google Forms to collect data from users. The reason I am doing this using Google Forms instead of the native Smartsheet form solution is because I need to add logic in the form so that some fields become mandatory to be answered depending on a previous selection. Well, the issue I'm facing is…
-
formula for dates
i have a question for a data sheet with completion dates i want to create a formula to count the lines marked completed with a date.. im using count if but is not working i was able to count the entries when no date available bu using ,"") at the end of the count if after my selection if any one can help me out with the…
-
Changing a Date (mm/dd/yyyy) to Month Year (January 2019)
I copied this from another post and simply substituted my date range (from another sheet) and It is returning "UNPARSEABLE". Any suggestions? =IFERROR(IF(MONTH(@{Quality Database Range 1}@row) = 1, "January ", IF(MONTH(@{Quality Database Range 1}@row) = 2, "February ", IF(MONTH(@{Quality Database Range 1}@row) = 3, "March…
-
Solicit Comments, but prevent user from viewing other's comments
Hello All, We use comments pretty extensively to communicate updates and share "next step" info internally. I would like to request updates, and include comments to external collaborators, but prevent them from seeing what has been previously posted. Is there a way to do this? Thanks, Alex
-
Count and compare date columns in 'form' based worksheet
I would like to know how I can count number of activities (rows) which are completed ('finish' date column) at or before 'planned finish' date. In the same formula it should only be counted when 'complete' column is ticked off and empty cells should not be counted. Note that this is a 'form based' worksheet, meaning rows…
-
SUMIFS for multiple criteria
This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense". I have tried a few variations, but this is what I think should work? =SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019). I have tried quotations around…
-
how to see the collaborators ?
I don't understand why you don't see the name of the collaborator and just show your email. What remains to be done so that it looks the same as the rest? See images please. Thanks
