-
Which is better in this case = Nested IF statement or using two formulas related to other columns
Hi, In the spirit of efficiency of memory usage, I want to figure out which methodology would be better: In either case, A/B are columns used to toggle several sheet functions as they relate to the heirarchy level the row is. * Use a nested IF statement: =IF(A@row = 0, SUM(CHILDREN()), IF(B@row=0, INDEX({REF Share},…
-
External Users and Security Access to Internal sheets
Can external users view internal sheets? Say someone outside our organization submits their bid, they get a notice that their bid was rejected and it gives them the link to our internal sheet. (see sample) I have only tested this using my own email address, so maybe they can’t see our sheet after all? If not the case how…
-
Power BI
Has anyone used Power BI with Smartsheet? I do a lot of things in Smartsheet, and we have another department doing things in Power BI. I see articles in Smartsheet about Power BI, but not sure what that means or if I have opportunities I should be investigating.
-
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…
-
Card View Stacked?
Hello, I understand why card view runs left to right. We are using card view to plan the layout of a 100 page magazine so we have 50 lanes. But there is only ever 2 tasks/cards per lane. Is it possible to stack the card view so we can see more lanes to view as visually this would be easier for us to manage this process?…
-
Hyperlink in a value cell with formulas
Hi, I have a hyperlink question and wonder if someone can help me out.... I have a cell with values auto calculated by a formula to show the number of task done. In this cell, I would like to add a hyperlink to a report so when I click the number I can see details in the report. However, it seems formula and hyperlink…
-
IF command and Date
Hi, I have 2 columns: Next Audit Due Date and Status If the date in ‘Next Audit Due Date’ column is greater than the current date, I would like the ‘Status’ column to fill in green and return value of On Track. If the date in ‘Next Audit Due Date’ column is less than the current date, I would like the ‘Status’ column to…
-
Conditional formatting based on time from today
I want to create conditional formatting rules on a Date column and cannot figure out how to enter Today in the criteria Example: Select column = EOL Date is < TODAY = Red is between TODAY() and TODAY() + 180 = Yellow is > TODAY() + 181 = Green I can do it in Excel just fine but when i enter TODAY() in the criteria it says…
-
forms and cell linking to a secondary sheet
Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time. Ive been trying to…
-
Trying to Auto-update due dates based on actual completion date
Hi, I am new to smartsheet and I am finding it very useful; except that I can't figure out how to auto-update completion dates. For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned to so I know when the project should be done. Building a house may require someone to build…
