-
COUNTIFS Description
I believe the description of COUNTIFS is misleading and basically just incorrect. It does not properly describe what it actually does. It says it counts the number of cells but it doesn't. It counts the number of times all given conditions in their respective ranges are met. One match of all given conditions in their…
-
how do you import an excel date/timestamp into smart sheet and have both date/time shown?
I captured date/timestamp in smart sheet 09/17/2020 13:35:44 and loaded this into smart sheet but the loaded value truncated the time, i.e, when loaded smart sheet showed 09/17/2020, but the time stamp was lost (truncated off). How can i also get the time stamp to be loaded, either in the same field or a departe field?
-
If Cell is Empty or Blank
Hi, I have created the following formula =IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Pending") > 0, "Pending", IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Created") > 0, "Pending", IF(COUNTIF([PCORI Reports]@row, "Requested"), "Pending", "Done"))) which is working efficiently, but…
-
Cannot transfer ownership of Smartsheet Calendar
I am trying to transfer ownership of a Smartsheet Calendar to a coworker, but when I try, it is giving me an error message, saying that the user isn't found and new user needs to be shared to the source sheet/report as an Admin in Smartsheet. I have checked, and this coworker is already an admin in all of the source…
-
Why is my multiplication formula invalid?
I am trying to create a column that multiplies the total hours by the pay rate of certain staff. In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", IF(Name1 = "Stephen", "55"))) This formula works well, however if I then try to use those values in another formula is just…
-
Dashboards on rows
Hello Everyone, I am trying to build a Dashboard, several teams in my Org. can use. The idea behind this is as follows: There is a separate sheet, which gets filled by using forms / row update. Each Team fills out their row initially by using the form and then does updates on certain fields via a workflow. A Dashboard…
-
Is there a way to show the report and give edit access to add comments and add attachments?
I have designed a workflow for our team and used the Request system workflow as a start. I created a report and attached the link in the email when someone submits the form. I have this report linked with the underlined sheet where my entire team works. V have information that shouldn't be shared with anyone outside the…
-
Using IFS statement with date and check box
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Finish, >=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…
-
Duration to a specific task from project start / counting the number of project days
Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project ("Project Day 1") up to the beginning of each task. For example, the first task would start on "project day 1," the last task of the project would start…
-
Counting Grandchildren Rows based on multiple criteria
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have children too (quarters). For each quarter, I need to count the number of grandchildren in that quarter that have a date in my "Date…
