-
Can you add a Sheet or Rpt to someone else's favorite as you share it?
Probably a no to the question above, but it was worth asking. I want to roll out a report to everyone in my group and force it in favorites for them to avoid "Where is that report?"
-
Past due formula keeps providing #INVALID DATA TYPE error
Hello, After much research and experimenting, I am still stuck on a formula for my status log. I am trying to create a formula that counts how many business days a task is past due. Therefore, the formula must check the due date, closed date, and status columns. The formula currently reads as this: =IF(ISBLANK([Due…
-
Unsure of formula or function to pull sales agent data from 2nd sheet
Currently we input all weekly sales results for our agents into sheet ONE named "2024 Agent Sales Activity" (1 row per agent with sales that week, with the primary column being the agent name "Last, First", and one of the other column is "Weekly Total"). In a SECOND sheet I'm setting up a lifetime sales tracker, with one…
-
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for. We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do…
-
VLOOKUP Not matching with Cell Reference but with String
I am doing a cross sheet VLOOKUP using this formula: =VLOOKUP(Region@row, {GC Consulting Approver}, 2, false). This returns a No Match error even though there is a match. If I use this version of the formula, =VLOOKUP("Americas Latin America", {GC Consulting Approver}, 2, false), it makes the match. The search value is in…
-
Moving Rows between sheets
Hi! I have a Original sheet with data being inputted by different users and locations. I was trying to build out reporting so I moved one locations data to another sheet. Is there any way to move it back to the original so I can change it to copy rows to the secondary sheet instead? I don't want to risk losing all the…
-
Error Notifications for Data Shuttle
I recently starting using Data Shuttle (awesome!) but as a beginner, I made a few changes to column names and it shut down the automated offload. When I went back into Data Shuttle I could see a large red X telling me it wasn't running and the last time it did run. I would really appreciate an email coming to me when the…
-
Adding Date using 'Today' or 'T'
I just found out that you can use the function 'Today' or just type the letter 'T' in any 'Date field' in smartsheet and it will populate the date. You can also do simple addition or subtraction to calculate for dates. This is on every date field, sheet summary, forms, automation, workflow, rules, send as attachement and…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Extract a number which is sandwiched between text
This discussion was created from comments split from: extract part of a cell's text.