-
Update Request - Error "Please enter a valid email address."
I was trying to send an update request to an audience of non-users and it kept failing to send to one email address. -My privacy settings were set to not restricted to smartsheet users. -When my work flow failed, I tried manually sending an update request and I kept getting this error. After reaching out to the help team,…
-
Issues with IF formula
Issue we need to resolve: The scope of work gets filled out by the client. The client has old information regarding location. In this example that location is 1-X-Kt/4.5. This location has been updated to 1-X-Kt/3.5 because of a remodel. We want the location to change to the updated location in a new column. Desired…
-
Time stamping checkbox
I am trying to create an IF formula on a cell to give me todays date when a checkbox is checked off. I tried the following but its giving me an error. =IF(DONE@row= 1, TODAY())
-
Date formula query
What formula to use, to calculate records from today till 6 months down the line? And this rule should be valid at all times. In other words, how to calculate sum of values eg: count of total number of projects starting from today (26/April/24) till 12 months down the line i.e. 26/October/24? For sum of values starting…
-
Index Match Help
Good afternoon, I'm trying to get my Index and Match formula to work, it was working correctly and has now broken and I'm not sure why. I Have a "Weekly Metrics" Sheet I'm Trying to pull information over to the "Weekly Metrics 2" Sheet I'm trying to get the data from Weekly Metrics to Weekly Metrics 2 by matching the dates…
-
IF (And statement with date columns?
I have tried several ways including Not(isblank and now using the current as blank fields and ISBLANK, and 0s, now just with quotes... it won't read both coluumns. it is say complete, even if only one column is not blank. i have another column with a similar formula that works GREAT, but it doesn't involve date columns.…
-
I am attempting to create a formula that counts the number of applications approved each week?
I have five different sheets collecting information about 5 different applications and each sheet has a date-approved column. I want to collect the number of approved applications for each application type, each week (1-52). I wanted to create a column formula that will count the applications that are approved if the…
-
Ability to mark comments as "saved for later"
I have noticed that once you read a comment you can't "save" it or mark it as unread. I find this very useful to remind myself of things I can't reply to straight away, but want to go back to. A list of "saved for later" comments could be provided per sheet, or as an overall list of all the saved comments.
-
Update Sheet/Cell via e-mail
Is there a way that a cell/sheet can be updated from an email? In my search, some seemed to think that a sheet is related to a specific email address, that when emailed with the correct format to declare column/row/cell, the chosen contents would end up on the sheet itself. Is this possible?
-
Subitems "Child Tickets" Automations
Hello, I recently started a new intake system within Smartsheet for our Training team. The way they structure tickets is unique. They have Parent tickets and Child Tickets. The individual requesting assistance from the training team can submit a ticket, but that ticket could have several deliverables . Each deliverable is…